Password / Auto_Open Macro Problem :-(

E

Ess101

Hi,

I recently made this macro in excel:

http://groups-beta.google.com/group...read/thread/4224d7377faa09d3/e008d26c6bdad365

I then made an Auto_Open macro consisting of the line "call
Highlighted_Text()" .

My workbook has always had a password. Since opening the workbook with
the Auto_Open macro, I am asked for my password as usual. But even
though I am entering the correct password, I am told that it is wrong
and to check if I have my SHIFT key turned off.

I CAN'T ACCESS THE WORKBOOK!!!!

I have tried pressing the SHIFT key different ways to make sure the
auto_open function is disabled but I've had no luck. :-(

Please, please, please could you show me how to solve this problem or
at least find a way of recovering the information held in the workbook
again.

Thanks in advance.

Kind regards,
Ess
 
D

Dave Peterson

Turn your security setting to medium. Then when excel prompts you to find out
if it should enable macros, tell it "no".

I would think that this would allow you to open your workbook at least.
 
E

Ess101

Hi Dave,

That allows me to get to the password input message box, but then even
after entering the right (I assure you, RIGHT!) password, I get the
message "it's wrong, please check if the Caps button is on".

I have also tried pressing shift and OK as I enter the password to
disable any macro.

Thank you for your suggestion.

Ess
 
W

Wild Jim

OK, first things first:

An aired of calm - then open up Excel - NOT the file you are having problems
with!

With a blank worksheet, goto Tools>Macro>Security.

Change the level to High.

Close Excel down altogether.
Re-open Excel and do the same again - it should have kept your security
level at high - if this is the case - leave it and click OK.

Now try to open your file.

When you get asked, DO NOT ENABLE MACROS.

The file should open.

Save it quick!! - After deleting your Auto_Open.
 
Top