Macro to print on sheets which are not hidden

**BRISBANEBOB** · 12-21-2008, 10:11 PM

I have a spreadsheet which has b=multiple sheets. Some users get to see on a selected number. I can't figure how to write a macro that will only print the 'unhidden' sheets.

I also can't figure out how to have page numbers, again, working on just the unhidden sheets i.e. if there are 20 sheets in the workbook, and only six are shown, the foot has only Page 1 - Page 6.

Finally (!), if there are three ranges on one page which need to be printed on individual pages, how can I get the pages numbers to increment to include these these but not hidden sheets.

**Steel Monkey** · 12-22-2008, 03:48 AM

Hi Bob

Please see below code which should help you out:

Please Login or Register  to view this content.

Im not sure what you mean exactly by : "if there are three ranges on one page which need to be printed on individual pages", how are these defined, are they named ranges ?

Hope this helps!