Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Worksheet Protection
Is there a way to protect a worksheet so that no one can change the Page
Setup setting such as margins, paper size, orientation, etc. Protection on the Tools menu does not seem to accomplish this. If it is not possible, I would appreciate this info. Will save a lot of time wasted. Thank you. Paul |
#2
|
|||
|
|||
I don't think it's possible.
But you could reset the page setup each time the user prints anything. If you record a macro when you do your specific settings, you could call that macro in the workbook_beforeprint event. (This won't have any effect if the user disables macros.) PA wrote: Is there a way to protect a worksheet so that no one can change the Page Setup setting such as margins, paper size, orientation, etc. Protection on the Tools menu does not seem to accomplish this. If it is not possible, I would appreciate this info. Will save a lot of time wasted. Thank you. Paul -- Dave Peterson |
#3
|
|||
|
|||
Thank you for confirming what I thought. You saved a lot of time.
"Dave Peterson" wrote: I don't think it's possible. But you could reset the page setup each time the user prints anything. If you record a macro when you do your specific settings, you could call that macro in the workbook_beforeprint event. (This won't have any effect if the user disables macros.) PA wrote: Is there a way to protect a worksheet so that no one can change the Page Setup setting such as margins, paper size, orientation, etc. Protection on the Tools menu does not seem to accomplish this. If it is not possible, I would appreciate this info. Will save a lot of time wasted. Thank you. Paul -- Dave Peterson |
#4
|
|||
|
|||
You could enable protection for all cells and protect your worksheet with a password. but be aware with about 20 lines of VB(A) the password of a worksheet can be cracked. -- Dnereb ------------------------------------------------------------------------ Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182 View this thread: http://www.excelforum.com/showthread...hreadid=397466 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Audit Tools with Worksheet Protection | Excel Discussion (Misc queries) | |||
Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
Prevent unhide of rows/columns w/out worksheet protection? | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) |