Consulting

Results 1 to 6 of 6

Thread: Solved: How to kill that finger (macro pointer)

  1. #1
    VBAX Tutor joelle's Avatar
    Joined
    Apr 2005
    Location
    Sunnyvale, CA
    Posts
    204
    Location

    Solved: How to kill that finger (macro pointer)

    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

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    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.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3
    VBAX Tutor joelle's Avatar
    Joined
    Apr 2005
    Location
    Sunnyvale, CA
    Posts
    204
    Location
    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

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    You have lots of squashed bullseye shapes in the worksheet.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Tutor joelle's Avatar
    Joined
    Apr 2005
    Location
    Sunnyvale, CA
    Posts
    204
    Location
    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?

  6. #6
    VBAX Tutor joelle's Avatar
    Joined
    Apr 2005
    Location
    Sunnyvale, CA
    Posts
    204
    Location
    I tried cut out that buggy section, re-entered lots of info.
    Yes, lengthy, but it works.
    Thanks for reading.
    Joelle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •