Hi all! Please help!
I use exstensibility to create code in worksheet module. This code deleteS the worksheet if sheet is deactivated. Code works perfectly. BUT excel crushes. Which isn't suprising: this is code that cannot end since it deletes its own parent object - worksheet.
Please any ideas how it can be accomplished? All i need is to delete a sheet if it is deactivated.
Many thanks in advance!!!!
Last edited by Alexander_Golinsky; 08-29-2013 at 11:06 AM.
Use the Workbook_SheetDeactivate event in the ThisWorkbook module?
Entia non sunt multiplicanda sine necessitate
WOW haven't know such a thing exists. Thank you !!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks