problems using printout method in excel 2007
 

I have written code to automatically do a proper pagesetup and then show a
print preview (someworksheet.printout preview:=true) to the user. I have
assigned this code to a button in a custom menubar.

when running the code (from the custum munobar) the user sees the
printpreview screen but all the print-buttons that are normally there in the
preview screen are gone
(for setup, margins, print etc). So the user has no means at all to print
from this preview screen. The only thing that works is the escape-button to
go back to normal layout screen. Do I have to manually set the proper menubar
in my code or is there another way around this ?