how to remove locked spreadsheet elements

[Marty]

Hello,

I have a spreadsheet and I want to remove some columns and other
elements but when I right-click on the top of the column the Delete
option is greyed-out.

Is there any way to get around this?

Thanks for your help!

 

[Otto Moehrbach]

Is the sheet protected? Is the workbook protected? HTH Otto

 

[Marty]

I don't know, how do I tell?

Is the sheet protected? Is the workbook protected? HTH Otto

 

[Otto Moehrbach]

Marty
In Excel earlier than 2007, click on Tools - Protection. If there is an
"Unprotect sheet", the sheet is protected. In 2007, click on Home and find
Format to the right. Click on Format and Protection. HTH Otto

 

[Marty]

Cheers Otto.

It was protected. I used this add-in to crack it:
http://www.mcgimpsey.com/excel/removepwords.html

Thanks for your help.

 

[Brad]

I find it is best to keep a running list of passwords written down some
place safe. You can also protect a sheet without a password.

Protecting a sheet can keep errors from occurring while making it very easy
to make changes if necessary. I use passwords on my templates just for that
reason. I am not as interested in third party changes nearly as much as I
am interested in preventing errors.

Brad

Excel 2002 on XP Pro SP 3
Excel 2007 on Vista 64

 

[Otto Moehrbach]

Glad I could help. Thanks for the feedback. Otto