Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically opening workbooks in macros brings up Enable Macr
I've been programmatically opening workbooks using Excel 2003 using the
following statement Set oWB = Workbooks.Open(oldPath, UpdateLinks:=False, ReadOnly:=True) Today, for the first time, every time a workbook is opened, I get the "Do you want to enable macros" question. To make it even more complicated, our organization is just starting to deploy office 2007, so I'm not sure if any of these workbooks have been edited using 2007. I'm thinking that using Application.DisplayAlerts = FALSE before the open statement should resolve my problem, but I'm wondering why it started now. These workbooks have had macros for over a year. Any ideas? Thanks, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable macros on a programmatically opening .xls file | Excel Discussion (Misc queries) | |||
Suppressing the Disable/Enable Macros Message Box Programmatically | Excel Programming | |||
How to realize "enable macro" by VBA when opening a file with macr | Excel Programming | |||
How do I turn off macros when programmatically opening a workbook. | Excel Programming | |||
creating workbooks(with macros and userforms) programmatically | Excel Programming |