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 |
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/ |
All times are GMT +1. The time now is 03:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com