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?

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

"Izwan" wrote:

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?

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

On Thu, 10 Jan 2008 18:46:05 -0800, Izwan
wrote:

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?