running a macro in excel 2000

  • Thread starter Thread starter allora
  • Start date Start date
A

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

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
 
Back
Top