PDA

View Full Version : How to Disable Set Print Area in Excel?



kirbz
11-18-2011, 07:01 PM
Hi,

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

thanks..

mikerickson
11-19-2011, 12:31 AM
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
11-20-2011, 09:09 PM
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
11-22-2011, 01:37 PM
this may help you to disable/enable comand bars and commands in xl2003.

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