Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have a spreadsheet data capture application that we require third parties
to use. We have discovered that one cheeky ***** has been adding his own company's logo in the page header when printing from the spreasheet. I would like to add our own logo on the template and then protect the 'Page Setup' so that it can not be changed. I have discovered how to disable the Page Setup item on the File menu: For Each Ctrl In Application.CommandBars.FindControls(ID:=247) Ctrl.Enabled = False Next Ctrl However when in Print Preview mode, the 'Setup...' button is still available. Is there a way to disable this? I don't know if this is relevant, but I am using Excel 2002 to create the template, and there is code within the template that puts up a message and closes the workbook if the version being used to complete the template is earlier than Excel 2000. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
print preview does not look like worksheet screen | Excel Worksheet Functions | |||
Print and Print Preview don't match screen | Excel Worksheet Functions | |||
Print Preview Screen in Excel? | Excel Programming | |||
How do I disable the Margins button in Print Preview Window | Excel Programming |