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.

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 <Jon...@discussions.microsoft.com> 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.

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 <Jon...@discussions.microsoft.com> 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.
>
>

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 <Jon...@discussions.microsoft.com> 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.
> >
> >