Prefenting opening template twice

[RiTiNi]

Hello VBA Masters,

I am looking for a vba script that prevents clumsy clicking (multiple times instead of double) when opening a template (excel) that causes two script sessions to run together with errors as a result.
Anyone an idea to solve this phenomenon?

 

[bobsan42]

Clicking on what?
If it is a command button - disable it on clicking and then enable it again when done.

 

[RiTiNi]

thnx for the swift reply.
It's clicking on the template-file to open excel and start a new workbook

 

[bobsan42]

It feels a bit weird to me to start excel in this way, but anyway ...
You can use an Application level variable to control if the code/scripts will run or not.
e.g. Application.EnableEvents, .EnableAnimations, .DisplayAlerts etc.

Private Sub Workbook_Open()
    If Application.EnableEvents Then
        Application.EnableEvents = False
        Call your_code
        Application.EnableEvents = True
    End If
End Sub

 

[RiTiNi]

Thnx for teh solution.
I've added to the script and no-more complains or fault-messages.