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: 33
Default Open workbook without running Workbook_Open Event

I'm using Excel 2007. How do I open a workbook (the workbook is a .xls
97-2003 format) WITHOUT running the Workbook_Open event? I tried holding down
the SHIFT key while opening as this worked in previous versions of Excel, but
the event still runs (unfortunately, there is an ActiveWorkbook.Close at the
end of my code so I can't get in to modify it :(

I'm sure there is a simple way to do this in 2007 but I do not know it.
Thanks for the help.
 
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
open a workbook without running Workbook_Open macro in E2007 Andreas Excel Programming 10 July 7th 09 06:41 PM
Workbook_Open event not called when workbook forced to re-open in read-only mode. Chrisso Excel Programming 2 May 15th 07 03:44 PM
Private Sub Workbook_Open() event won't fire if workbook is hidden? Mike Weaver Excel Programming 2 February 15th 06 01:38 PM
Private Sub Workbook_Open() not running on open Tim[_39_] Excel Programming 0 August 30th 04 09:11 PM
OnTime event not firing in Workbook_Open event procedure GingerTommy Excel Programming 0 September 24th 03 03:18 PM


All times are GMT +1. The time now is 03:07 PM.

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"