I would like to run a small VBA macro on several sheets in a workbook, but not all sheets.
I have found this code works for all worksheets but I do not want every sheet included:
ANy ideas?
![]()
Please Login or Register to view this content.
I would like to run a small VBA macro on several sheets in a workbook, but not all sheets.
I have found this code works for all worksheets but I do not want every sheet included:
ANy ideas?
![]()
Please Login or Register to view this content.
Change Name1 and Name2 to the sheets you don't want to run the code.
you can add more sheets like And xSh.Name <> "Name3"......
![]()
Please Login or Register to view this content.
Click the * Add Reputation below to say thanks.
Thank you. That helped.
Thanks for the feedback.
I also did some further searching and found this. It works by including the sheets rather than excluding them. I realized I needed this approach as I will add sheets in the future I do not want to be effected by the macro.
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks