Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Sheet from Page Setup
Hi, I have a form that is distributed to others, and the sheet is protected
except for the cells that they have to make changes in. My problem is that sometimes they change the margins on the sheet. Is there any way to protect the page setup so that others cannot make changes? Thank you for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Sheet from Page Setup
Hi,
When you password protect your sheet , be sure that only the select unlocked cell is check otherwise they will have acces to modify it "Churley" wrote: Hi, I have a form that is distributed to others, and the sheet is protected except for the cells that they have to make changes in. My problem is that sometimes they change the margins on the sheet. Is there any way to protect the page setup so that others cannot make changes? Thank you for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Sheet from Page Setup
Thank you.
I have tried this, but without success. I noticed that even if the entire sheet is protected, changes can still be made to the page setup. "Eduardo" wrote: Hi, When you password protect your sheet , be sure that only the select unlocked cell is check otherwise they will have acces to modify it "Churley" wrote: Hi, I have a form that is distributed to others, and the sheet is protected except for the cells that they have to make changes in. My problem is that sometimes they change the margins on the sheet. Is there any way to protect the page setup so that others cannot make changes? Thank you for your help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Sheet from Page Setup
I don't think so.
If it's really important (and the user enables macros!), then you could add some code in the workbook_before print that changes the print settings to what you want. But you may want to consider this. With all the printers that are available, I wouldn't be surprised if changing the margins (on at least one printer) makes the output prettier. Churley wrote: Hi, I have a form that is distributed to others, and the sheet is protected except for the cells that they have to make changes in. My problem is that sometimes they change the margins on the sheet. Is there any way to protect the page setup so that others cannot make changes? Thank you for your help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to setup a excel sheet to be protect after save and close file | Excel Discussion (Misc queries) | |||
Can I protect the page setup? i.e. 45% landscape | Setting up and Configuration of Excel | |||
Excel page setup Sheet Print Cells Error As... | Excel Discussion (Misc queries) | |||
Copy Page Setup from Sheet to Sheet? | Excel Discussion (Misc queries) | |||
protect format - page setup | Excel Discussion (Misc queries) |