Macrobutton not behaving as expected

  • Thread starter Thread starter Alan D.
  • Start date Start date
A

Alan D.

I'm trying to use a macrobutton field to initiate the emailing of a form,
but when the form is protected, clicking on the field once just bounces the
cursor to the next available formfield. My understanding was that the
macrobutton field should be functional in a protected for. Am I missing
something? Thanks for any help!

Regards,

Alan D.
 
Hi Alan,

A single click on a macrobutton field is interpreted as an attempt to
select the field, and selection of anything except a form field isn't
allowed in a protected form. The macro named in the macrobutton field
will be activated by a double-click.

You can change this behavior by putting these two macros in your form
template:

Sub AutoNew()
Options.ButtonFieldClicks = 1
End Sub

Sub AutoOpen()
Options.ButtonFieldClicks = 1
End Sub
 
Well, it wasn't responding to double-clicks either, but it must've been me
because it does so now. However, the single-click capability is very nice
and so easy to implement. Thanks!

Now, a follow-up. I'm wanting to pre-fill the recipient for an email, but
I'm not wanting to assume that the user has Outlook (which everything I've
been reading about, such as the Route function, seems to reference). Is
there any to do that?

Thanks again.

Alan D.

--------
 
Back
Top