Set deactivating worksheet as variable in Worksheet_Deactivate event
Dear all,
I am using below code to set deactivating sheet as variable in "Aws" but it sets the sheet we switch to.
I know its obvious.
I wanted to know if there is any trick to use "Deactivating sheet" as variable..?
I am keying-in this code in 'Sheet1(Sheet1)' excel objects and i am planning to use this code over hundred+ of sheets.
Please suggest.
Please Login or Register to view this content.
Thanks
Maybe:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If you're going to use the same event in all your sheets, you would be better served to use a single Workbook level event in the ThisWorkbook module:
Please Login or Register to view this content.
Thanks..Works like charm...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks