| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect format - page setup
I've protected parts of my sheet, but also want to protect it's format. I
don't want the user to use page setup to alter the appearance. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
protect format - page setup
Hello,
Did you find a solution cause I'm searching also a solution for this ? Thanks François "kva" wrote: I've protected parts of my sheet, but also want to protect it's format. I don't want the user to use page setup to alter the appearance. Any suggestions? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
protect format - page setup
There's a workbook_beforeprint event that you can use to reset any changes to
the page settings. I don't think you can protect it any other way. François wrote: Hello, Did you find a solution cause I'm searching also a solution for this ? Thanks François "kva" wrote: I've protected parts of my sheet, but also want to protect it's format. I don't want the user to use page setup to alter the appearance. Any suggestions? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Sheet from Page Setup | Excel Discussion (Misc queries) | |||
| FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
| Can I protect the page setup? i.e. 45% landscape | Setting up and Configuration of Excel | |||
| In excel how do I copy page setup format from one wsht to another | Excel Discussion (Misc queries) | |||
| protect format - page setup | Excel Discussion (Misc queries) | |||
Hybrid Mode
