Run code only on selected sheets

[ericsastud]

I have a template that I need to add the ability to run code (print, format, etc..) only if the sheets are selected. Several sheets will be selected simultaneously, and I want the code to run only on those sheets.

Most of the solutions I have seen require you to know the name of the sheets. In this template, sheet names are always changing. Also, the number of sheets changes. Sometimes we have a workbook with 3 sheets, sometimes with 100+.

Thanks in advance for the help!

[TMS]

Not sure what you want to do exactly.

The following code selects three sheets and does a Print Preview.

Please Login or Register  to view this content.

If the sheets were already selected, you could just run the PrintPreview.

This code displays the sheet name for each selected sheet:

Please Login or Register  to view this content.

Something to try?

Regards

[ericsastud]

Thanks for the response. Sorry if I wasn't clear enough. I was actually thinking of something like this (except of course this doesn't work):

Please Login or Register  to view this content.

The problem lies with being able for my code to know which sheets have been selected.

[Richard Buttrey]

Hi,

How about

Please Login or Register  to view this content.

Rgds