Hi

Is there a macro command to print all visible sheets in a workbook.


I have a workbook that, depending on which macro is run, ununhides up to 3 of 9 hidden sheets.

I hope to create a button on the front page that will print the visible sheets irespective of which sheets are actually displayed.

or do I have to setup seperate macros with each combination of visible sheet names in it?

thanks