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
Bookmarks