Event Procedure doesn't run

[pat59]

Hi,
I'm new to Excel programming. I tried successfully to use a Workboo
event macro.
I could not say why after I deleted a different macro, this procedure
Workbook_BeforeSave) no longer runs.

Could anyone helps me?
Thanks in advance, regards
pa

 

[NickHK]

What does this show ?
MsgBox Application.EnableEvents

If False then in the Immediate window set it True
Application.EnableEvents=True

NickHK

 

[pat59]

Thanks for your answer NickHK, it shows True.
The fact is that I wrote this procedure in 'ThisWorkbook' module, bu
now, if I press F8 to step into or whatever key, I get the Macros Lis
window with no other ability to run the function.
Probably depends on my absolute lack of VBA knowledge, but I wa
wondering if I need to define a macro that somehow call the even
procedure?..
This morning everything worked fine...
thanks

bye,
pa

 

[Tushar Mehta]

An event procedure is something that XL runs when a particular event occurs.
BeforeSave would be run by XL just before it were to save the workbook. The
user doesn't get to run them through the UI.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions