running a macro in excel 2000

[allora]

I have a workbook with a macro which was created in excel
97. However, when I retrieved this workbook in excel
2000,it doesn't display the prompt that we used to have in
excel 97 whether we want to disable or enable the macro.
Anyway,I want to have Excel 2000 run the macro. When I
open the workbook it says that Visual Basic macro module
is now edited in the VB editor, not the workbook. When I
go to Tools menu, macro command, Project Window, modules
and run it, it says that the macro is disabled. How can I
enable the macro, so that when Excel opens the workbook,
the macro will run automatically.

 

[Ron de Bruin]

Hi allora

Tools>Macro..Security
Change the level to medium

 

[Paul B]

Allora, is your security settings on high, if so the macros want run
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[allora]

thanks for your help

 

[Gord Dibben]

allora

Also sounds like the macro was created in Excel 95 which was the last version
to feature the Menu Editor.

You probably have the macro in a macromodule sheet rather than a module,
although should work anyway, I believe.

Gord Dibben Excel MVP