Macro wont Run with shorts

[toughie]

I have a userform open and my Application.visible = False on start up,

i want to add a macro that will

Application.visible = True with assigned shortcut Ctrl+Shift+Z

it currently does not work and have ran out of ideas, any help is appreciated?​

 

[Yongle]

Are you sure that it is even possible to do that?

A different approach - UserForm doubleClick event

Private Sub UserForm_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    Application.Visible = True
End Sub

or toggle like this - you may need to use {Tab} to find the userform if it disappears

Private Sub UserForm_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    With Application
        .Visible = Not .Visible
    End With
End Sub

restrict to specific user?

Private Sub UserForm_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    If Application.UserName = "ABC" Then
        Application.Visible = True
    Else
        Cancel = True
    End If
End Sub

What is your Excel user name?

MsgBox Application.UserName

 

[toughie]

Yeah i wasnt sure if it was possible but this approach will be better, im unsure what my excel username is or where to find it?

 

[Yongle]

I'm unsure what my excel username is or where to find it?

That is why I gave you the last line of code in post#2

MsgBox Application.UserName

 

[toughie]

Thats it! problem solved thanks so much