De-select worksheets after printing in Excel

De-select worksheets after printing in Excel I have setup a excel worksheet that uses multiple sheets for calculations that don't need to be printed. My entire workbook has 8 sheets and I normally only print the first 4. The workbook may be printed multiple times as I am editing it.
Asked by: Guest \| Views: 248

Total answers/comments: 2

Comments display order:

Guest [Entry]

"Just record a macro.

I would save the macro to the file itself, and create a shortcut key for it so that all you have to do is press 'ctrl+shift+p', for example, and it will print the desired sheets and return the workbook to just having one sheet selected.

Press record
select the sheets to print
Print
ungroup the sheets
stop recording."

Guest [Entry]

"You could use a macro assigned to a hot key, for either of the options

a) http://www.vbaexpress.com/kb/getarticle.php?kb_id=125

b) http://excel.tips.net/Pages/T003157_Setting_Print_Ranges_for_Multiple_Worksheets.html"