Unwanted Hand

[Graham Haughs]

I have a worksheet where a hand instead of the cursor appears when the sheet
is protected. It is not specific to any particular cell. I know it may be
associated with a hyperlink of which there were two in separate cells at one
time. These have since been cleared and are no longer active. The hand only
appears in the protected sheet and when clicked, regardless of where it is
in the sheet, it activates code which is associated with a button on the
sheet. It is workbook program but the problem is specific to this one sheet.
I just cannot seem to shake it and would welcome any suggestions. Excel
2000.

Kind regards
Graham Haughs
Turriff, Scotland

 

[Graham Haughs]

Sorry to follow up to my own posting but I just discovered that if I do not
protect the "objects" under the protection options it eliminates the
problem. I would still like to know what is happening though.

Graham Haughs

 

[pfsardella]

Right click on the cells causing the problem. If you have the
Hyperlink Menu, there is still a link there. Select "EditHyperlink" >
Remove Link.

--------------------------------------------------------------------------------------------

Or if that's not the issue.

Is there an invisible button or other object that covers the cell? If
so,

Forms Toolbar Control : Right click. If "Assign Macro" is present on
the menu, hit "Cut" to delete.

Less likely as you have the hand pointer.

Control Toolbar Menu : Right click on a Toolbar. "Control Toolbox".
Click "Design Mode" icon. Click on the offender button. Right click .
Hit cut.
--------------------------------------------------------------------------------------------

Or not likely, since you have the hand pointer.

From Excel. Alt F11 to access VBE. Ctrl-F (find).
"NameOfProcedureConnectedToButton". Search the whole project, but I
would expect to find it in the WorkSheet's code. Comment out the
statement that calls that "NameOfProcedureConnectedToButton".

 

[Graham Haughs]

Thanks Paul for the comprehensive reply. Problem is now solved.

Graham.