Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Margin
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Footers from Margin to Margin | Excel Discussion (Misc queries) | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Mark up and Margin | Excel Worksheet Functions | |||
To make a margin | Excel Discussion (Misc queries) | |||
Right margin will not change. | Excel Worksheet Functions |