Page Setup in Excel

I

Izwan

hai there,

Can anyone help me!!1 i currently development a standard excel sheet for my
company. I would like to protect the margin(page setup) from any user
modified.How could i do that?
 
D

Don

Tools / Protection / Protect sheet = depending on what version of Excel will
depend what you will see but you should be able to check the sections that
protect formatting. Dont forget the password
 
G

Gord Dibben

I don't know of any way to lock that setting from change.

Maybe add a BeforePrint event that checks the margin size and cancels printing
if they have been changed.

Along with a message telling users to go reset to your size.


Gord Dibben MS Excel MVP
 
Top