I am using Excel 97.

I have written some templates in excel.

Because of their layout, if the normal print options are
used they don't print how I want them so I have recorded
some code so they do print how I want them.

Can someone provide me with some code which disables the
PRINT & PRINT PREVIEW in the FILE menu options, disables
the print button on the STANDARD toolbar.

I don't know whether I am asking too much but to replace
the print button on the standard toolbar with a button
which runs my recorded print code.

But of course on closing the excel spreadsheet resets
everything!

Any help would be greatly appreciated.


Mark

You can disable the menu options: but this interferes with the user interface somewhat

Why not use the event

Sub Workbook_BeforePrint(Cancel As Boolean
Cancel = True ' Cancels printin
Your macr
End Sub

Since your printing routine will raise this event this event too, this solution will not be viable! Sorry.

Not if his code disables events, prints, enables events.

--
Regards,
Tom Ogilvy

"AA2e72E" <(E-Mail Removed)> wrote in message
news:37BACC1C-530A-46A8-AFCB-(E-Mail Removed)...
> Since your printing routine will raise this event this event too, this
solution will not be viable! Sorry.