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

G

Guest

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.
 
G

Guest

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=create+survey&btnG=Google+Search

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

enable macro automatically when we open a workbook 2
To Enable Macro in Excel. 2
Enabling/Disabling OptionButtons, CheckBoxes etc. in another works 1
Execute a macro automatically when checkbox is clicked 3
How to apply a macro to all workbooks 2
VBA code won't run, even with Macro Security set to Enable All Macors 9
security, enabling macros to enable a disabling saving function 12
Hiding All Checkboxes when I open/close the workbook 3

Top