Can't step thru Workbook_BeforeClose

[merlynsdad]

I can't step through my Workbook_BeforeClose procedure. It's not running correctly, and I need to check it. When I put the cursor beside "Private" and hit the step thru button nothing happens. Is stepping thru this procedure different than any other?

 

[SkipVought]

hi,

Please post your code, as my immaginer facility as apparently not working and probably would yield faulty results if it were.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[merlynsdad]

Private Sub Workbook_BeforeClose(Cancel As Boolean)

''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''''''''''
'THIS MODULE CLOSES THE WORKBOOK AND EXCEL
'WITHOUT GIVING THE USER THE OPPORTUNITY TO SAVE
''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''''''''''
On Error Resume Next

Application.EnableEvents = False
Workbooks(cstrDatabaseWB).Close False
Me.Saved = True
Application.EnableEvents = True
Application.DisplayAlerts = False
Application.Quit

End Sub

 

[SkipVought]

I can't step through my Workbook_BeforeClose procedure.

You mean that you cannot step INTO the Workbook_BeforeClose procedure.

so...

put a BREAK in the first line of code.

close your workbook.

enter DEBUG.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]