CANCEL EXCEL BUTTONS

[mn12]

Hi All,
in my program I create report by excel and open it from vb.
I open the report in "display before print" .when displaying before print is open, there are some buttons there that I want to cancel,or to cause them to be disable.
(those buttons are standard part of excel).how can I "control" those buttons by using vb code?

 

[JESTAR]

You just switch the ToolBar off... if you told us which toolbar it is and where it is.

 

[mn12]

HOW can I switch the toolbar off?
I mean,the toolbar you see when you use the "printPreview"
command,(not the standard toolbar of excel)

 

[mudstuffin]

Hello.

Try running the print preview with this:-

ActiveSheet.PrintPreview False

the false on the end prevents any changes being made.

Regards,



mudstuffin