Disable Setup button on Print Preview screen
 

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.

Disable Setup button on Print Preview screen
 

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.

Disable Setup button on Print Preview screen
 

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.

Disable Setup button on Print Preview screen
 

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.