Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Ghost Hand on my worksheet

  Asked By: Hamish    Date: Nov 15    Category: MS Office    Views: 753
  

When we protect our sheet and we move toward the top (from A1:G25,
respectfully) we get a hand on mouse over anywhere in that area...

we found on the VBE Sheet a MACRO "button_29Click"... so we delete it
out and then on opening we would get an error...

so we put it back in and the error goes away... there isn't a lick of
any button anywhere on that sheet and we can't figure it out...

any ideas???

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Alexis Castillo     Answered On: Nov 15

Let's find out:
with that sheet  the active sheet:
press Alt+F11 to open the vbe  (visual basic editor)
Make sure the immediate window's open with Ctrl+G (or View|Immediate
Window)
then type the following line in that pane followed by [Enter]:
?activesheet.shapes.count
if the result's not zero then enter the next line folllowed by
[Enter]:
for each shp in activesheet.shapes:?shp.name:next

You might get something like this:
CommandButton1
CommandButton2
CommandButton3
Button 29

in which case you've got some buttons on the sheet but not visible.
Come back  with what you get and we'll take it from there.

 
Answer #2    Answered By: Dot net Sachin     Answered On: Nov 15

We actually created a little function following your code guidelines...
Turns out there were 2 shapes each on the 3 sheets, so we just did a
shapes.delete...
Worked like a charm...

 
Didn't find what you were looking for? Find more on Ghost Hand on my worksheet Or get search suggestion and latest updates.




Tagged: