Macro cannot be found

B

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
 
D

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

Barney

Nothing in either view.

Dave Peterson said:
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.
Click to expand...
 
B

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
 
D

Dave Peterson

Try this:

Edit|goto|Special
check Objects

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

Barney

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

Thanks.

Barney
 
B

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
 
Top