PDA

View Full Version : Solved: How to kill that finger (macro pointer)



joelle
10-22-2008, 09:13 AM
Dear Experts,

I have several macros (with a click) in my spreadsheet but recently
I cannot fix one glitch there.
All the buttons I created (bull-eyes) look the same but for a couple of "named" sections there, the hand/finger pointer just does not go away and this prevents user from select a cell or any cells in those sections
(hardware, peripherals, connector in the attached sample spreadsheet)

In reality, my spreadsheet is much bigger and all other sections work fine
with protected mode. Any idea?

Thanks a lot.
Joelle

lucas
10-22-2008, 09:25 AM
I can't reproduce your problem. I clicked the one bullseye and it took me to the bottom of the sheet.....I was then able to click on any cell.

joelle
10-22-2008, 10:57 AM
Hi Lucas,

That bulleye is a good one (I might not be clear earlier)

I mean when you hover your mouse over the bad sections (hardware, peripherals, connector) you will see the hand/finger and you CANNOT click on any cell in those sections.
My headache is, why is the hand/finger there when you hover over those section without clicking any button????? and I forgot to say, that hand/finger only shows up in protected mode.

(pls note edit "cannot")

Many thanks.
Joelle

Bob Phillips
10-22-2008, 11:11 AM
You have lots of squashed bullseye shapes in the worksheet.

joelle
10-22-2008, 11:59 AM
I know, and I need them all.
but if someone can point out to me why the hand/finger shows up in those sections when the spreadsheet is protected, I really appreciate it.
I have a lot of bulleyes macros but they did not gimme problem until recently.
Again, I dont think we are limited by the numbers of macros in a sheet, if they dont grow to like 100 macros?

joelle
10-23-2008, 02:37 PM
I tried cut out that buggy section, re-entered lots of info.
Yes, lengthy, but it works.
Thanks for reading.
Joelle