View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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.