Hi I want to protect a worksheet's Formats, but allow editing - is this possible? Dion
C Custy Mar 20, 2009 #1 Hi I want to protect a worksheet's Formats, but allow editing - is this possible? Dion
D Dave Peterson Mar 20, 2009 #2 Select the cells that should be ok for editing. Format|Cells|Protection Tab|Uncheck locked Then protect the worksheet tools|protection|protect sheet There are lots of features that are disabled when you protect the worksheet. You may want to check to see it this is really what you want.
Select the cells that should be ok for editing. Format|Cells|Protection Tab|Uncheck locked Then protect the worksheet tools|protection|protect sheet There are lots of features that are disabled when you protect the worksheet. You may want to check to see it this is really what you want.
