Macro cannot be found

[Barney]

Using Windows XP and Excel 2002. When I protect my spreadsheet and
subsequently click on any cell, locked or otherwise, I get a dialog box that
says "The macro "2006SeniorScoring.xls!SuperSeniorAlpha" cannot be found."
I do not have a macro by that name although I did at one time. How can I
rid myself of this pesky dialog? It seems to be preventing me from
navigating with the mouse and forces me to use the arrow keys for that
purpose.

Thanks in advance.

Barney

 

[L Scholes]

Try going to VBA editor (ALT+F11) and deleting the offending project?

 

[Barney]

That is the problem. the 'offending project' isn't listed.

 

[Barney]

I searched all modules for 'SuperSeniorAlpha' and it was not found.

 

[Dave Peterson]

Try rightclicking on the worksheet tab that has the trouble.

Select View code

Is there anything in that module that calls that supersenioralpha macro?

If there isn't, then look under the thisworkbook module, too.

It kind of sounds like you have some _selectionchange event firing.

 

[Barney]

Nothing in either view.

Try rightclicking on the worksheet tab that has the trouble.

Select View code

Is there anything in that module that calls that supersenioralpha macro?

If there isn't, then look under the thisworkbook module, too.

It kind of sounds like you have some _selectionchange event firing.

 

[Dave Peterson]

Are you clicking on a cell or are you clicking on an object/shape?

 

[Barney]

I am tring to click in a cell. I have no objects or shapes. For some
reason, my mouse pointer is the small hand instead of the normal cross???

Barney

 

[Dave Peterson]

Try this:

Edit|goto|Special
check Objects

Do you get a "No Objects Found" message back?

 

[Barney]

I do not get that message. It highlites all my buttons which are each
assigned to macros.

Thanks.

Barney

 

[Barney]

Dave,

Using your tip (below), I found extra objects I didn't know were there.
Those were removed and my problem seems to have been fixed. Thanks for
hanging in there with me.

Barney