Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    May 2016
    Posts
    50
    Thanks
    9
    Thanked 4 Times in 4 Posts

    Spin Button (Form Control) odd behaviour

    ok, so i have a spin button on my worksheet, linked to a cell out of view, and then back to the cell next to it via a formula in that cell, so i can alter the formatting, and display a zero with the sheet set to hide them, and also so i can leave said cell locked, because the spin button cannot adjust locked cells


    so all is good, i have not assigned a macro to the spin button, as i do not need it to trigger anything, hence why i have not used the activeX version, also the form one is nicer to look at, and doesn't need messing around with so it doesn't take focus on click.

    The only oddity i have, and i don't understand why it would do it by design, is that when in unlocked mode, moving the mouse over the spin button results in a hand icon, perfect..... however, when you lock the spin button, and then the sheet, the icon changes as you mouse over still, but this time to the northwest arrow ...... wtf


    anyone got any idea if this is a bug or what ? obviously i can live with it, but it would be nice to have the hand icon back, as the other objects on the worksheet have that

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Gunslinger

    You can only change the mouspointer to a hand icon if you use the activeX version of the control (and you'll also need a .ico file for the pointer you want to use).

    zeddy

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    The easiest workaround I can think of is to assign a macro that doesn't do anything to the control.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. The Following User Says Thank You to rory For This Useful Post:

    Gunslinger (2016-06-13)

  5. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    ..but that would just give the 'arrow pointer' and not the 'hand pointer'

    zeddy

  6. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Not for me. Gives the hand pointer by default.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi rory

    ..did you protect the worksheet???

    see my attached workbook - please let me know if you still get the hand pointer when the sheet is protected (no password)

    zeddy
    Attached Files Attached Files

  8. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Yes I did. You didn't assign a macro to the spinner, which is why you don't get a hand.
    Regards,
    Rory

    Microsoft MVP - Excel

  9. The Following User Says Thank You to rory For This Useful Post:

    zeddy (2016-06-13)

  10. #8
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi rory

    You are correct.

    I assigned a dummy to me and used my hand to slap myself on the head.
    I lost track when I was testing in Excel2016 and earlier versions.

    zeddy

  11. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Regards,
    Rory

    Microsoft MVP - Excel

  12. #10
    Star Lounger
    Join Date
    May 2016
    Posts
    50
    Thanks
    9
    Thanked 4 Times in 4 Posts
    excellent idea to use a blank macro, i will go incorporate that

    thank you

Posting Permissions

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