Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following opens the file, accessess the file, no problem.
I need code to "select" the default "macros NOT enabled" Setting. Otherwise, I'm constantly getting a error message. I've tried using 'select'. I need the screenupdating = False, because of size and complexity of file. Sub BB_Chassis_Draft() Application.ScreenUpdating = False Workbooks.Open ("S:\10_SALES MANUALS\Z_JFS\0_Spread_Sheets\10_Modifications\7_N EW 2006\4_Updating\BB-Pup-Chassis-2006_R1C0.xls") Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA select default Don't Enable / Enable macros Setting | Excel Programming | |||
Enabled macros | Excel Programming | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
enable macros as default | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |