Results 1 to 4 of 4

Workbook_Open doesn't run on second open

Threaded View

carsto Workbook_Open doesn't run on... 12-29-2009, 12:14 PM
romperstomper Re: Workbook_Open doesn't run... 12-29-2009, 12:20 PM
carsto Re: Workbook_Open doesn't run... 12-29-2009, 12:32 PM
romperstomper Re: Workbook_Open doesn't run... 12-29-2009, 12:33 PM
  1. #1
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Workbook_Open doesn't run on second open

    I have noticed this on more than one workbook with an Workbook_Open macro.

    When you open Excel, open Workbook1, do some work , save or don't save and close, then reOpen Workbook1 without having closed the Excel application, the Workbook_Open macro in Workbook1 doesn't run.

    Closing Excel and reopening Workbook1 initiates the Workbook_Open macro. It's as if Excel remembers having previously opened Workbook1 and so it doesn't rerun the Workbook_Open macro the next time you open it.

    Is this a bug or can I program around it?
    EXCEL 2000
    Last edited by carsto; 12-29-2009 at 12:32 PM. Reason: solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1