Disabling normal printing

[Mark]

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

 

[AA2e72E]

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

 

[AA2e72E]

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

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

Since your printing routine will raise this event this event too, this

solution will not be viable! Sorry.