View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarcoR
 
Posts: n/a
Default Printing hidden worksheets

Hi.

I have a worksheet (Worksheet1)with a command button to print out 4 other
worksheets.
I used Sheets(Array("Sheet2","Sheet3","Sheet4","Sheet5")) .PrintOut
This is working fine.
Now, I want to hide the Sheets2-5 and be able to use the command button to
print them all out.
How is this done?