Thread: Protect Margin
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Protect Margin

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

On Mon, 14 Jan 2008 00:59:01 -0800, Izwan
wrote:

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