How to Disable Set Print Area in Excel?

[kirbz]

Hi,

I would just like to ask for help.. does anyone know how to disable the Set Print Area in Excel 2003?

thanks..

[mikerickson]

I don't know how to disable Set Print Area.
Would it work for you to force a particular Print Area setting in the BeforePrint event? Rather than prevent the user setting the Print Area, just undo what they did.

[mgm05267]

Hi kirbz,

hope you know how to set print area...

its in page setup...

below set print area, you have clear print area too...

Regards,

MGM

[mancubus]

this may help you to disable/enable comand bars and commands in xl2003.

http://www.rondebruin.nl/menuid.htm