var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Pause sub
Is there any way to pause a sub, so something else can be done in a excel sheet and then after some time or for example a sheet get focus to continue that sub
For a length of time wait you can use
or to completly halt the macro just stop it, write a text command somewhere in your workbook so that the new event will run only when this happens
'at end of your sub
Worksheets("Sheet2").Range("A1").Value = "GO"
Private Sub Worksheet_Activate()
If Not Range("A1").Value = "GO" Then Exit Sub
MsgBox "Run Here"
That was exactly what I was looking for