Excel xp is protecting my worksheet so I cant modify them anymore.

  • Thread starter Thread starter jb
  • Start date Start date
J

jb

I have a worksheet from my company for my monthly expenses. In the past I
would take the sheet from the previous month, modify it, save it /renaming
to the new month, print and mail it in.

now, my computer has been baselined from 2000 to XP, with office XP.

Now, when I make my changes, save as new name, and re-open; I cant edit any
field.( dates, amounts,etc...) Every cell says " The cell or chart you are
trying to change is protected and therefore read-only. To
modify.....Unprotect Sheet command..."

I cant unprotect it because even the original HAS protected cells/and macros
for some formulas so it's password is from my company which I dont have.

I can open and edit all previous months.
If I save changes I cant edit them anymore.
If I send the files to my co-worker who's system is still on 2000 and excel
2000 he CAN edit my files that are now locked to me!!

any suggestions?
j.b.
 
Hi jb!

Take a trip to:

http://www.mcgimpsey.com/excel/removepwords.html

Download the AllInternalPasswords.xls file
Open that file
Open your file
Tools > Macro > Macros
Select "AllInternalPasswords"
Run

Follow instructions (very simple ones).

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
HAHA,
I didn't refresh before I posted my other reply!!
I found your link in another reply you made.

It does work (GREAT) but I still need to figure out why excel is locking
them in the first place.

j.b.
 
Hi JB!

If you are saving after AllInternalPasswords has done its job, then
there must be a subroutine that is coming in and imposing the password
again.

Open again
Remove passwords again
Right click a worksheet tab
Select View Code
Select the workbook name in the top left Project Explorer window
Double click the ThisWorkbook module
Take a look at any event handling code in there

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Open again
Remove passwords again
Right click a worksheet tab
Select View Code
Select the workbook name in the top left Project Explorer window
Double click the ThisWorkbook module
Take a look at any event handling code in there
Click to expand...

This is on workbook tab:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

-----------------
this is on general tab:

Sub Macroprotect()
'
' Macroprotect Macro
' Macro recorded 3/12/99 by katina *********
'

'
ActiveWorkbook.Protect Structure:=True, Windows:=False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
ActiveWorkbook.Unprotect
ActiveSheet.Unprotect
End Sub


again though, it's only on excel xp (my machine) that I cant edit the files
 
Hi jb!

Check for code on the ThisWorkbook tab

It looks like this is where the problem is.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top