2 questions, Hide print preview buttons and accessing hidden sheets

Instead of posting two separate messages I thought I'd ask them both in one since they both should be easy to answer.

First, I have a report generator which at the end shows the report in the Print Preview screen. Is there any way I can hide several of the buttons in the print preview screen? Like, Page Setup, Margins, etc. I want to hide all buttons except for the Print and Close buttons. Is it possible? Can it also default to 'zoomed in' ?

Second, is there a way to access, (copy and paste), from a sheet that is hidden? Or do I 'have' to unhide it before this can be done?

Sorry for the (very) late reply.

Thanks for your help with this. I am still not sure how to remove the buttons from the print preview though. The ID for what you posted was 109. What can I do with that?

The second part is OK now. Even though formula works actually copying and pasting doesn't seem to. So, I just simply un-hide the sheet and re-hide it.

I would however still like to hide the buttons mentioned previously in the print preview screen if possible.