| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
| kill "enable macros" message | Excel Discussion (Misc queries) | |||
| Suppress "Disable/Enable Macros" and Query Refresh dialog on open | Excel Programming | |||
| How to realize "enable macro" by VBA when opening a file with macr | Excel Programming | |||
| Code to ignore on-screen message concerning "Enable Macros." | Excel Programming | |||
Hybrid Mode
