Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet protection
Hi,
I have a workbook with several worksheet. All I want is to have 2 worksheets to be protected against deletion. But when I take the option protect worksheet, I only can protec everything in it but not the deletion of the worksheet. And if I take the option protect workbook, then ALL my woorksheet ar protected and I don't want that because my macro will create worksheet that may be deleted. Can someone give a solution for my problem please -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet protection
Protecting the workbook is the only protection that protects sheets from
deletion. And it doesn't not let you selectively determine which sheets are to be protected. -- Regards, Tom Ogilvy "masterflasher " wrote in message ... Hi, I have a workbook with several worksheet. All I want is to have 2 worksheets to be protected against deletion. But when I take the option protect worksheet, I only can protect everything in it but not the deletion of the worksheet. And if I take the option protect workbook, then ALL my woorksheet are protected and I don't want that because my macro will create worksheets that may be deleted. Can someone give a solution for my problem please? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Protection | Excel Worksheet Functions | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
protection of worksheet | Excel Discussion (Misc queries) |