Workbook_BeforeClose event to apply to active workbook

[Charles Bushby]

I have a workbook with code that disables cut copy and paste which works fine. On opening the code disables these functions and on closing it enables them. However if I have two workbooks open with this code and I shut one of the workbooks it then enables cut copy and paste in the remaining workbook. I don't want this to occur.

What should I put in the Workbook_BeforeClose event that only enables the code to apply to the active workbook and not other ones that would remain open?

 

[mvptomlinson]

Hi Charles,

Instead of using the Workbook_Open or BeforeClose events, use the Workbook_Activate and Deactivate events. You can then enable/disable the commands when switching between workbooks.

 

[Charles Bushby]

That works perfectly - many thanks.

Charles

PS it was excel 2003