| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alter macro security level programmatically
I have an Access application that is opening a number of Excel spreadsheets
and reading data from them. Each of these spreadsheets has the same macros, which I want to disable when I open the workbook, rather than having to click the pop-up window that asks if I want to enable/disable macros. Is there a way to do this using Excel automation? How about using API calls? My intent is that I would like to read the current setting, change the setting to disable macros, read in the files, then reset the setting to its original value. -- Don''t forget to rate the post if it was helpful! email address is invalid Please reply to newsgroup only. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro-Security level value | Excel Programming | |||
| set macro security level through VBA | Excel Programming | |||
| ??Programmatically set security level to medium | Excel Programming | |||
| Using VBA to change macro security level | Excel Programming | |||
| Macro to change security level | Excel Programming | |||
Threaded Mode
