Password / Auto_Open Macro Problem :-(

  • Thread starter Thread starter Ess101
  • Start date Start date
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
 
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.
 
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
 
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.
 
Back
Top