Deleting Rows in a Protected Worksheet

[jmueller]

I've got an Excel XP worksheet which is Sheet Protected as well as "Range" protected. The range protected is from cell A4 to the very last cell (IV65536) and specify a password. Upon protecting the sheet I check the INSERT ROWS & DELETE ROWS options to allow for these options. I then SHARE the workbook but I don't believe that matters (but maybe). After doing the above, I can insert rows but when I try and Delete a row, it says I can't because some cells in the row are Locked. Can somebody offer me any advice?

Thanks in advance!

Jack.

 

[SkipVought]

Hi,

Unlock the cells that can be modified.

If it hurts when you hit your head with a hammer...

stop hitting your head with a hammer!



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[jmueller]

Thanks for the response Skip, although unlocking the cells allows me to delete a row, it defeats the purpose of having password protection on a range of cells. In other words, if I unlock the cells, it no longer asks for a password when attempting to edit them and also allows for anyone to access the sheet and make changes. I would think applying a password to ALL cells in the sheet and upon a password being entered, would allow for deleting a row since all the cells should be unlocked. Any other ideas? Am I missing something?

 

[SkipVought]

What version of Excel?

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[KenWright]

Straight out of help from Excel 2003 on 'Shared Workbook'

You can't Protect or unprotect worksheets or the workbook whilst in Shared mode - Existing protection remains in effect.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[jmueller]

It's Office XP, Excel 2002 SP-2

 

[SkipVought]

Cells do NOT get unlocked with a password. The password get you to the sheet WITH all the protection that has been set.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[jmueller]

Sure they do... that's what the option "Allow users to edit a range" is for... you specify the range and assign a password. Upon attempting to enter data for the first time, excel prompts for a password and then all cells in the specified range are freed up for editing.

 

[KenWright]

No - as Skip said, the password gives you access to the sheet. Depending on whether or the cell's individual status was locked or unlocked when the *sheet* was protected you will either be able or unable to edit that particular cell. Hence the option Tools / Protection / Protect Sheet.

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------