LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default choose default macros Not Enabled / Macros Enable Setting

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA select default Don't Enable / Enable macros Setting BEEJAY Excel Programming 1 June 29th 06 08:45 PM
Enabled macros raw[_13_] Excel Programming 1 December 14th 05 10:59 AM
Open workbook-macros enabled, opening another with macros George J Excel Programming 5 September 17th 04 02:07 PM
enable macros as default josh Excel Programming 2 June 10th 04 12:52 PM
Suppress the Disable Macros / Enable Macros Dialog Shoji Karai Excel Programming 5 September 24th 03 03:10 AM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"