Is your macro connected to Excel (global) or to the specific file? Put the
macro in global (press ALT-F11, drag your macro from file to global) if it's
not there already. Excel97 has a hard time associating button with macro
for local (file only) macros sometimes
Martin Kurr
email [log in to unmask]
> From: Tony Beckett[SMTP:[log in to unmask]]
> Subject: [PCSOFT] Excel97 Menus and macros
> I recorded/wrote a macro specific to a particular Excel workbook
> and wanted to run it via a new command on the Tools menu item.
> This worked. However every time I use the workbook I have to
> "re-connect" the macro to the command on the Tools menu item
> as I get an error message saying the macro cannot be found.
PCSOFT maintains many useful files for download
visit our download web page at:
http://nospin.com/pc/files.html
|