Disable commad bar options

  • Thread starter Thread starter nath
  • Start date Start date
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.
 
-----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
 
-----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
 
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.
 
Back
Top