Page Setup in Excel

[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?

 

[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

 

[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