Workbook_Open operates inconsistently

[dhregan]

Hello -

I have a simple Workbook_Open macro (in the ThisWorkbook module) as follows:

Private Sub Workbook_Open()

' Ensure that calculations and screen updating are ON
    Application.Calculation = xlCalculationAutomatic
    Application.ScreenUpdating = True


' Leave workbook in working state if last save was in debug mode
    If Range("DEBUG_FLAG").Value = False Then
        Call Set_Defaults
    End If


' Default Migrate Flag to false so that regular processing can commence
    Range("MIGRATE_FLAG").Value = False


End Sub

I get inconsistent behavior when opening the workbook. Normally on the first open attempt, the Workbook_Open macro does not run. However, on the second attempt, the macro runs. Has anyone seen this before? Thanks in advance for any thoughts on a remedy.

 

[rlv01]

I too have experienced unreliable operation from Workbook_Open. It's why I still rely on the older auto_open instead.

 

[dhregan]

I too have experienced unreliable operation from Workbook_Open. It's why I still rely on the older auto_open instead.

Hello rlv01 -

Would the auto_open reside in the ThisWorkbook module? I assume that I would also delete the current Workbook_Open macro to avoid any conflicts, correct?

 

[rlv01]

The auto_open macro resides in a standard code module.

 

[rlv01]

cross posted

http://www.vbaexpress.com/forum/showthread.php?64460-Workbook_Open-operates-inconsistenly

 

[Fluff]

@dhregan
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[dhregan]

@dhregan
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

My apologies. I will remember to do so next time.