Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open
Is there a parameter that I can pass to auto enable the macros of an
Excel spreadsheet that I'm opening with Workbooks.Open? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open
I'm not sure I understand.
If you're code is using workbook_open to open another file, then the macros in that workbook about to be opened will be enabled. If the user chooses not to allow macros to run, then your workbook_open event won't even run. This choice is a security setting that each user has to set. wrote: Is there a parameter that I can pass to auto enable the macros of an Excel spreadsheet that I'm opening with Workbooks.Open? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Workbooks.Open closes other workbooks | Excel Programming | |||
Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming |