Susan,

Don't worry, I've found it - 109. I think will have to disable the Print
menu item (ID = 4) and Ctrl-P shortcut as well, as there is also a Preview
button on the print dialog box. Thanks again,

Jon.

"Jon Ley" wrote:

Susan,

Fair comment! I may well just end up doing that. You don't happen to have
the Control ID number off-hand do you?

Thanks,

Jon.

"Susan" wrote:

don't know if you can disable the Setup button on the Print Preview,
but why not just disable the Print Preview?
:)
just an idea
susan


On Nov 30, 8:48 am, Jon Ley wrote:
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.