Using Excel 2000 vba I would like to

1. disable the <PRINT button and other buttons programmatically.

2. tab from button to button.

3. be able to view the PrintPreview picture programmatically.

Your help will be appreciated.

Raymond

Hi Raymond,

Raymond wrote:
Using Excel 2000 vba I would like to

1. disable the <PRINT button and other buttons programmatically.

You can disable the print button with this:

Application.CommandBars.FindControl(ID:=2521).Enab led = False

I found the ID by doing this in the immediate window:

?application.CommandBars("Standard").Controls(6).c aption
Print (<my printer)

?application.CommandBars("Standard").Controls(6).i d
2521

2. tab from button to button.

Not sure what you mean by this.

3. be able to view the PrintPreview picture programmatically.

ActiveSheet.PrintPreview False

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]