Hello wonderful excel community,
I'm creating a template for users of both mac and excel and have received feedback that the cursor occasionally disappears on Mac Excel. I've done some testing and have discovered that it appears to happen after I use an input box.
This only happens when you press the 'enter' key. If you select 'OK' with the mouse, it seems to be fine.
Here's a link to a screen capture. The first time I choose select 'OK' with the mouse and it works fine, the 2nd time I hit 'Enter' and it disappears. Is this just a bug with Excel for Mac or is there something I can do about it?
https://streamable.com/dmx5z
Here's the code:
Sub EPW()
Dim EnteredPassword As String
Dim Password As String
Password = "password"
EnteredPassword = InputBox("Insert Password")
If EnteredPassword <> Password Then
MsgBox "Sorry! Wrong Password!"
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
Exit Sub
End If
End Sub
Thank you wonderful people!
I'm creating a template for users of both mac and excel and have received feedback that the cursor occasionally disappears on Mac Excel. I've done some testing and have discovered that it appears to happen after I use an input box.
This only happens when you press the 'enter' key. If you select 'OK' with the mouse, it seems to be fine.
Here's a link to a screen capture. The first time I choose select 'OK' with the mouse and it works fine, the 2nd time I hit 'Enter' and it disappears. Is this just a bug with Excel for Mac or is there something I can do about it?
https://streamable.com/dmx5z
Here's the code:
Sub EPW()
Dim EnteredPassword As String
Dim Password As String
Password = "password"
EnteredPassword = InputBox("Insert Password")
If EnteredPassword <> Password Then
MsgBox "Sorry! Wrong Password!"
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
Exit Sub
End If
End Sub
Thank you wonderful people!