Macro to confine cursor to set boundaries

[mackensteff]

Hello,

Is it possible by vba to restrict the mouse movements to a given area of the screen. Ideally, I would like the cursor to be confined to a large button area once the button is pressed and triggers a macro, but by pressing esc or a similar key regain free movement, but then be confined to the button area once it is pressed again. Is this remotely possible (or does that even make sense)?

Thanks!!

 

[Jaafar Tribak]

Hello,

Is it possible by vba to restrict the mouse movements to a given area of the screen. Ideally, I would like the cursor to be confined to a large button area once the button is pressed and triggers a macro, but by pressing esc or a similar key regain free movement, but then be confined to the button area once it is pressed again. Is this remotely possible (or does that even make sense)?

Thanks!!

Could be done with a few API calls ? Is the button on a Userform or on a worksheet ?

 

[mikerickson]

Would this work for you.

Sub ToggleBoundary()
    With ActiveSheet
        If .ScrollArea = "" Then
            .ScrollArea = "A1:F10"
        Else
            .ScrollArea = ""
        End If
    End With
End Sub

 

[mackensteff]

Hello,

Jaafar the button is on a worksheet. mikerickson Thanks for the code. I would have mentioned I am using a Mac. I tried the code and it didn't do anything. Looking into it I saw others had issues with ScrollArea support in Excel for Macs. The other, and most likely option, is I don't know what I'm doing.

 

[Jaafar Tribak]

Hello,

Jaafar the button is on a worksheet. mikerickson Thanks for the code. I would have mentioned I am using a Mac. I tried the code and it didn't do anything. Looking into it I saw others had issues with ScrollArea support in Excel for Macs. The other, and most likely option, is I don't know what I'm doing.

If it wasn't a Mac, I could have posted some code.

 

[mikerickson]

I'm on a Mac too.
The code I posted worked for me. Attach it to a forms menus command button. Press the button once, and you can only scroll in A1:F10, press again, you can scroll anywhere. Note that F11 will be visible both when scrolling is restricted and when not.

 

[mackensteff]

I don't know what I am doing wrong then. I did as you said last night and tried again just now and nothing happens when I press the button. Sorry for the trouble.

 

[mikerickson]

Is the button assigned to the macro? Is the macro in a normal module, not the sheet's code module?

 

[Jaafar Tribak]

Is the button assigned to the macro? Is the macro in a normal module, not the sheet's code module?

Hi Mike,

I think that by "cursor" , the OP is refering to the mouse pointer

 

[mikerickson]

Yeah, he might be. Super dictator app. If my mouse was suddenly restricted, if I couldn't click on quitl, it would scare the willies out of me.