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