ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   assign macro to delete event (https://www.excelbanter.com/excel-programming/308709-assign-macro-delete-event.html)

mai

assign macro to delete event
 
Hi, I want to call my macro when my user tries to delete a worksheet
How can I assign this macro?

I've thought of writing an if-statement in Private Su
Workbook_Activate() - or something along this line, but it's no
working and I'm not sure which declaration I should use. Can anyon
help?!

Thanks

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com