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.

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.

--
Regards,
Tom Ogilvy

"nath" <n@n wrote in message ...

-----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.

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.

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