Protect Margin

[Izwan]

Hai there, befere this i've already try the suggestion the thing doesn't
workup.I'm using Microsoft Xp SP2 and Micsrosift Office 2003. My question is,
i would like to protect spreadsheet page setup (margin: top,bottom,
right,left) from being alter by user. How could i do that? Thanak you

 

[Gord Dibben]

This was my answer to your original post.

..........................................................
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.
..............................................................................

I will amend that answer and add this.

Or the beforeprint code could override any users' changes and reset to your
given size before printing.


Gord Dibben MS Excel MVP