Hi, and Many Thanks in Advance!

Using the following code:

For Cbar = 1 To Application.CommandBars.Count
For Each Ctl In CommandBars(Cbar).Controls
Application.CommandBars(Cbar).FindControl(Id:=4
Recursive:=True).Enabled = False
Next Ctl
Next Cbar

I can disable the different CommandBars print Controls,
but the printPreview Print Control is still enabled

1) Is it possible to disable it, and how??

--
Message posted from http://www.ExcelForum.com

Try doing it with ID=109

Print Pre&view=109 ... at least for XL2003 and 200

--
Message posted from http://www.ExcelForum.com

with 109, I will disable the printpreview.

i know that.


But:

is it possible, enable the PrintPreview controls and disable the Prin
control located within the PrintPreview

--
Message posted from http://www.ExcelForum.com