ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable printPreview's Print Control! is it possible???? (https://www.excelbanter.com/excel-programming/309712-disable-printpreviews-print-control-possible.html)

Andoni[_42_]

Disable printPreview's Print Control! is it possible????
 
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


Ivan F Moala[_10_]

Disable printPreview's Print Control! is it possible????
 
Try doing it with ID=109

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

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


Andoni[_48_]

Disable printPreview's Print Control! is it possible????
 
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



All times are GMT +1. The time now is 08:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com