How do I automatically "enable Macros" when opening a workbook
 

I want to send out a "questionaire" to non-techies and want to automatically
enable macros when opening the Excel worksheet. Maybe there is an application
more suitable than Excel? I want to use CheckBoxes and possibly a Button to
execute code that would reset multiple CheckBoxes.

How do I automatically "enable Macros" when opening a workbook
 

You would have to certify your workbook and the non-techies would have to
accept your certificate as trusted.

If you don't and their security is set to high, it would be opened with no
prompt and macros disabled.

There are some free survey sites on the web where you can create
questionaires.

http://www.google.com/search?hl=en&q...=Google+Search

Zoomerang is the one I was thinking of but there are others to look at.

--
Regards,
Tom Ogilvy


"RobertWNewson" wrote:

I want to send out a "questionaire" to non-techies and want to automatically
enable macros when opening the Excel worksheet. Maybe there is an application
more suitable than Excel? I want to use CheckBoxes and possibly a Button to
execute code that would reset multiple CheckBoxes.