Printing hidden sheets
 

i have some data on a sheet that is "very hidden" and
that sheet is used to compile a certain report based on
criteria selected by the user. well anyway, i want that
sheet to remain hidden and be printed out when the user
has finished selecting his/her data, and clicks a "print"
CommandButton. however i get an error when the sheet is
hidden. is there anyway a user can print a "very hidden
sheet?"

Printing hidden sheets
 

AFAIK you must unhideprinthide

--
Don Guillett
SalesAid Software

"spence" wrote in message
...
i have some data on a sheet that is "very hidden" and
that sheet is used to compile a certain report based on
criteria selected by the user. well anyway, i want that
sheet to remain hidden and be printed out when the user
has finished selecting his/her data, and clicks a "print"
CommandButton. however i get an error when the sheet is
hidden. is there anyway a user can print a "very hidden
sheet?"