Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting sheet protection
Hi people!
I want prevent of deleteing sheets I originally have. I have a Macro who add a new sheet, which must be deleteable. OK. I know how to protect whole Workbook, but it's not what I need ,because I can't add new worksheet. (delete too) Any help! Vlado |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting sheet protection
Another thing:
New sheets from macro are colored: ..........ActiveWorkbook.ActiveSheet.Tab.ColorInde x = 34 Maybe is possible to disable Delete< in relation of tab color. Something like. If ActiveSheet.Tab.ColorIndex < 34 then disable Delete Is that possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting sheet protection
In you code,
unprotect the workbook, add the sheet, reprotect the workbook. -- Regards, Tom Ogilvy "VK" wrote in message ... Hi people! I want prevent of deleteing sheets I originally have. I have a Macro who add a new sheet, which must be deleteable. OK. I know how to protect whole Workbook, but it's not what I need ,because I can't add new worksheet. (delete too) Any help! Vlado |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting sheet protection
Tom,
This would be good option but, problem is this new sheets must be daleteable for user. I don't know how manage that. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting sheet protection
Provide an interface for the user, such as a menu item or command button
that executes your code that deletes the sheet. -- Regards, Tom Ogilvy "VK" wrote in message ... Tom, This would be good option but, problem is this new sheets must be daleteable for user. I don't know how manage that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Q about sheet protection | Excel Discussion (Misc queries) | |||
Sheet Protection | Excel Worksheet Functions | |||
Sheet protection error msg - Unrequested sheet activation | Excel Programming |