Disable commad bar options

N

nath

Hi

I have created a complex report on Excel and have created
a print button that sets the print area of the sheet to
only include relevant (occupied) cells. With this in mind
i would like the users to use my print button rather than
having the print button on the command bar as there would
be 30+pages with the majority being blank.

Is it possible to disable the command bar print button?

Or if i remove it and then save it using right click, will
it still be removed on other users?

TIA

Nath.
 
N

nath

-----Original Message-----
Hi

I have created a complex report on Excel and have created
a print button that sets the print area of the sheet to
only include relevant (occupied) cells. With this in mind
i would like the users to use my print button rather than
having the print button on the command bar as there would
be 30+pages with the majority being blank.

Is it possible to disable the command bar print button?

Or if i remove it and then save it using right click, will
it still be removed on other users?

TIA

Nath.
.
done it now thanks.
Click to expand...

I have used application.CommandBars(3).Controls(4).Enabled
= False
 
N

nath

-----Original Message-----
Hi

I have created a complex report on Excel and have created
a print button that sets the print area of the sheet to
only include relevant (occupied) cells. With this in mind
i would like the users to use my print button rather than
having the print button on the command bar as there would
be 30+pages with the majority being blank.

Is it possible to disable the command bar print button?

Or if i remove it and then save it using right click, will
it still be removed on other users?

TIA

Nath.
.
done it now thanks.
Click to expand...

I have used application.CommandBars(3).Controls(4).Enabled
= False
 
T

Tom Ogilvy

Did you disable Ctrl+P, how about the print buttons in the print preview -
there are a lot of places one can print without using your button.

As I recommended, you might want to use the BeforePrint event.
 
Top