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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jb - 01 Apr 2004 08:49 GMT

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.

Reply to this Message

Norman Harker - 01 Apr 2004 09:32 GMT

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

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Reply to this Message

jb - 01 Apr 2004 10:11 GMT

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.

Reply to this Message

Norman Harker - 01 Apr 2004 10:28 GMT

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

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
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!!
[quoted text clipped - 5 lines]
>
> j.b.

Reply to this Message

jb - 01 Apr 2004 12:53 GMT

> Open again
> Remove passwords again
[quoted text clipped - 3 lines]
> Double click the ThisWorkbook module
> Take a look at any event handling code in there

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

Reply to this Message

Norman Harker - 01 Apr 2004 14:48 GMT

Hi jb!

Check for code on the ThisWorkbook tab

It looks like this is where the problem is.

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

>
>> Open again
[quoted text clipped - 30 lines]
> again though, it's only on excel xp (my machine) that I cant edit
> the files

Reply to this Message

jb - 01 Apr 2004 09:51 GMT

I have tried this:
http://www.mcgimpsey.com/excel/removepwords.html
-thanks Norman

but it unlocks the Entire sheet and it's STILL locked again when I reopen
it.

Reply to this Message