Run same macro on multiple sheets but not every sheet

**Crawfy** · 04-26-2019, 05:45 AM

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.

**dotchiejack** · 04-26-2019, 06:26 AM

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.

**Crawfy** · 04-26-2019, 08:27 AM

Thank you. That helped.

**dotchiejack** · 04-26-2019, 08:29 AM

Thanks for the feedback.

**Crawfy** · 04-26-2019, 07:03 PM

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.

Run same macro on multiple sheets but not every sheet

LinkBack

Thread Tools

Rate This Thread

Display

Run same macro on multiple sheets but not every sheet

Re: Run same macro on multiple sheets but not every sheet

Re: Run same macro on multiple sheets but not every sheet

Re: Run same macro on multiple sheets but not every sheet

Re: Run same macro on multiple sheets but not every sheet

Thread Information

Users Browsing this Thread

Similar Threads

Macro - To copy rows from multiple sheets to one sheet

[SOLVED] Copy data from multiple sheets to one sheet macro

[SOLVED] Need Macro to combine columns from multiple sheets together in a new sheet

Macro to Extract Data from Multiple Sheets into One Sheet

Excel 2007 : Macro to combine data from multiple sheets into one sheet

Macro to Copy Data from One Sheet onto Multiple Sheets

Macro - copy value only from multiple sheets into one sheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions