Macro error at cell:

[Sobek]

Hi
One of my users has been receiving following error msg
when she opens excel 97:

In the title bar:

"Microsoft Visual Basic"

"Compile error in hidden module: TN Reg Code"
when I click "OK", I get another window with "Macro Error"
in the title bar and msg saying: "Macro error at cell:
[AUTOSAVE.XLA]AutoSave!B202"

I have four buttons
"Halt"
"Step"
"Continue"
"Goto" (is greyout)

When I click "Halt" it takes me to same error msg but
number at the end is B203

Can you please help me with this problem.

Regards
Martin

 

[GJones]

Hi Martin;

It will generate an error if you try to use the select
method in a sheet that is in the XLA.

Hope that helps!

Greg

 

[Dave Peterson]

First, these are guesses.

It kind of sounds like a setting or two got screwed up in the autosave.xla
addin.

If you can continue after getting all those prompts, you could try resetting all
the parms (under tools|autosave).

If that doesn't work, (but you could still open excel), I'd turn off autosave.

Tools|Addins|uncheck autosave

Then find that autosave.xla and delete it. Reload it from your installation CD.

(I think those settings are stored in the .xla file itself--so deleting and
reinstalling from a good copy may work.)

If you can't get to excel, you may have to go through the registry to turn off
that addin.

In xl2002, the registry key is:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options
(look for OPEN, OPEN1, OPEN2, etc.)

(that 10.0 will be 9.0 for xl2k or 8.0 for xl97--her version.)

These have to be in nice consecutive order. So you might have to rename some to
make them consecutive again (after you delete the offending one).

And since you're working in the registry, make sure you back it up before you
start.


===
And you didn't ask, but Jan Karel Pieterse has an addin that's very nice:
AutoSafe (note spelling)

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)

======
If you don't share with that user, you may want to get a copy for yourself!

Hi
One of my users has been receiving following error msg
when she opens excel 97:

In the title bar:

"Microsoft Visual Basic"

"Compile error in hidden module: TN Reg Code"
when I click "OK", I get another window with "Macro Error"
in the title bar and msg saying: "Macro error at cell:
[AUTOSAVE.XLA]AutoSave!B202"

I have four buttons
"Halt"
"Step"
"Continue"
"Goto" (is greyout)

When I click "Halt" it takes me to same error msg but
number at the end is B203

Can you please help me with this problem.

Regards
Martin