Greetings,
This is my VBA for 1st sheet of my workbook,
It is in the Module 1
Please Login or Register to view this content.
Also I have
In worksheet (a) Selection change of Excel Object.Please Login or Register to view this content.
My question is how I can to "RUN" same VBA for other 7 sheets (b - h) of same workbook ?
Thanks for your help
Last edited by maftoun; 06-12-2012 at 03:38 PM. Reason: Use code tags in future.
You have two lines:
Just remove them, and copy the worksheet_selectionchange event to each of the worksheets you need the functionality on. Since you are already on the worksheet, you don't need to select it. Also, I normally don't select sheets (or cells) any more than necessary, it slows down VBA quite a bit.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks