Macro name not appearing in macro list in Excel 97

[Henner]

Hi

When I open a spreadsheet that contains a macro in Excel 97, the macro name doesn't appear in the 'Macro Name' window, so I can't run it. This only occurs on 1 Windows 98 PC. It's OK on 2 others.

I've tried completely uninstalling and reinstalling Office 97 (and the 2 Office 97 service packs using the MS Erase utility) but this made no difference.

Has anyone seen this problem before and know what could be causing it please?

Thanks
Paul
This message was edited by Henner on 2002-09-27 14:07

 

[Mark O'Brien]

There could be several reasons.

If the word "Private" is used to declare the macro:

e.g.

<pre>
Private Sub Test()</pre>

then you will not see the macro in the macro list.

did you create the macro yourself? If so, how did you create it? Typing the code or using the macro recorder or copying and pasting from somewhere else?

This will give us a good start to solving your problem.

HTH

 

[Henner]

Hi Mark,

Thanks for your reply. No, I didn't write it and no, the word Private is not present.

When I open it on 2 other Windows 98 PC's, I can see the macro name, step into it and run it. I can only assume it is some problem with Office 97.

 

[Mark O'Brien]

Is the macro in a standard module?
It's not a function is it? i.e. it has "sub" in the definition, not "function"