| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting worksheet properties
How can you prevent others from renaming a worksheet?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting worksheet properties
Protect the structure of the workbook.
Tools|Protection|Protect workbook No renaming sheets, no inserting of sheets, no moving of sheets. But this protection can be broken by anyone who really wants to break it. ITQuestioner wrote: How can you prevent others from renaming a worksheet? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting worksheet properties
Does this also prevent copying sheets to another workbook?
Thanks! "Dave Peterson" wrote: Protect the structure of the workbook. Tools|Protection|Protect workbook No renaming sheets, no inserting of sheets, no moving of sheets. But this protection can be broken by anyone who really wants to break it. ITQuestioner wrote: How can you prevent others from renaming a worksheet? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting worksheet properties
What happens when you tried it via Edit|move or copy sheet?
What happens if you just select the range (all the cells) and do edit|copy and Edit|Paste? ITQuestioner wrote: Does this also prevent copying sheets to another workbook? Thanks! "Dave Peterson" wrote: Protect the structure of the workbook. Tools|Protection|Protect workbook No renaming sheets, no inserting of sheets, no moving of sheets. But this protection can be broken by anyone who really wants to break it. ITQuestioner wrote: How can you prevent others from renaming a worksheet? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting format properties when opening Worksheet | Excel Worksheet Functions | |||
| Setting printing properties | Excel Programming | |||
| Setting Tab Properties in Excel | Excel Discussion (Misc queries) | |||
| Setting properties to combobox | Excel Programming | |||
| setting properties for shapes | Excel Programming | |||
Hybrid Mode
