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

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.
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
J

jb

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.
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
J

jb

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top