Good evening all the peeps of the Excel Community. This one has me completely flammuxed but hopefully someone can spot my obvious error that I can't ... I...

Using Excel 2003. Whenever I try to change a formula or formatting, I get a message that says, "This cannot be performed on a protected sheet. To...

do we have a way by which we can break a password protected excel worksheet.....it doesnt open..it asks for password whenever i try to open it....thanks...

I have an Excel financial form that I copy and rename each time I need fill it out for a new client. I am now finding that random cells are protecting...

I have protected my workbook so users can only modify certain cells. I have a Button to clear all cells, but when I protect the workbook, the button is...

I have the following code in the 'BeforeClose' routine of my spreadsheet: Sheets("Lists").Unprotect Range("Lists!I1").Value = "" Sheets("Lists").Protect...

Hi, Is there a way to unprotect a spreadsheet if you do not know the password...

Hi All! I need to unprotect (forever) a workbook in Excel 2003. I've tried doing what Help says (Tools Protect Unprotect Workbook); however, no...

I believe I'm fairly decent at programming in excel, but I can't figure out this problem. I've created a spreadsheet with a lot of accounting data on it...

Hi, I am trying to insert rows in a sheet that was setup by someone else. When i try use the insert row function i get a message stating that excel...

i am trying to run a workbookopen macro but i keep getting an error staing that i am trying to edit a protected worksheet or cell. I do have all of...

I have a spreadsheet (Excel 2003) in which I have 2 option buttons grouped together to give an either/or choice. These are linked to a cell which return the...

Hi, Is there anyway to unprotect a worksheet to allow me to see the formula used in certain cells. I'm prompted for a password but do not have the...

Hello is it possible to unprotect a worksheet when a certain cell is selected using VBA . I need to unprotect the worksheet when cell B34 is selected and...

I protected the worksheet and made some cells available and others off limits. Now I want to make some changes to the spreadsheet but Tools/Unprotect...

Realtively new to 2007, and yesterday just protected the workksheets and the workbook apparently. Now I need to unprotect them for some changes, but on the...

I try to see the formulas behind a cell.Since the sheet or workbook is protected I couldnt see it.This is the old file and I forgot the unprotect password.How...

Hi, I have a client who created a workbook with a hidden, password protected sheet included. She sent it out to a client of hers who then faxed back the...

I want to unprotect my estimating workbook. My password works to open the workbook but doesn't work to unprotect the workbook. (1) If I choose...

Using Excel 2007, how do you unprotect the workbook in an Excel 2003 file. The protect workbook function actually indicates it is not protected, but I know...