Hi,
I'm new to Excel programming. I tried successfully to use a Workbook 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
pat
Hi,
I'm new to Excel programming. I tried successfully to use a Workbook 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
pat
What does this show ?
MsgBox Application.EnableEvents
If False then in the Immediate window set it True
Application.EnableEvents=True
NickHK
"pat59" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
> I'm new to Excel programming. I tried successfully to use a Workbook
> 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
> pat
>
>
> --
> pat59
> ------------------------------------------------------------------------
> pat59's Profile:
http://www.excelforum.com/member.php...o&userid=31861
> View this thread: http://www.excelforum.com/showthread...hreadid=562790
>
Thanks for your answer NickHK, it shows True.
The fact is that I wrote this procedure in 'ThisWorkbook' module, but now, if I press F8 to step into or whatever key, I get the Macros List window with no other ability to run the function.
Probably depends on my absolute lack of VBA knowledge, but I was wondering if I need to define a macro that somehow call the event procedure?..
This morning everything worked fine...
thanks
bye,
pat
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
In article <[email protected]>,
[email protected] says...
>
> Thanks for your answer NickHK, it shows True.
> The fact is that I wrote this procedure in 'ThisWorkbook' module, but
> now, if I press F8 to step into or whatever key, I get the Macros List
> window with no other ability to run the function.
> Probably depends on my absolute lack of VBA knowledge, but I was
> wondering if I need to define a macro that somehow call the event
> procedure?..
> This morning everything worked fine...
> thanks
>
> bye,
> pat
>
>
> --
> pat59
> ------------------------------------------------------------------------
> pat59's Profile: http://www.excelforum.com/member.php...o&userid=31861
> View this thread: http://www.excelforum.com/showthread...hreadid=562790
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks