B
Brad
I have created a quote template that is all based in userforms, which I
created in XP SP2 with office 2003 SP3. Most users are able to use the
template, however a couple of users are experiencing problems. When they
click on "Enable Macros" at the Security Warning box before opening the
sheet, Excel completely freezes. There is a little bit of code in 'This
Workbook'. The code is:
--------------------------------------------------------------
Option Explicit
Public BooleanForClosing As Boolean
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Unload Formalstep1
Unload Formalstep2
Unload FormalStep3
Unload Quickquote1
Unload Tools
End Sub
Private Sub Workbook_Open()
Dim awb As Workbook
Set awb = ActiveWorkbook
awb.Activate
Sheets("Tools").Range("A1").Value = ""
Dim usrid As String
usrid = Environ("Username")
Sheets("Data").Range("K123").Value = usrid
End Sub
created in XP SP2 with office 2003 SP3. Most users are able to use the
template, however a couple of users are experiencing problems. When they
click on "Enable Macros" at the Security Warning box before opening the
sheet, Excel completely freezes. There is a little bit of code in 'This
Workbook'. The code is:
--------------------------------------------------------------
Option Explicit
Public BooleanForClosing As Boolean
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Unload Formalstep1
Unload Formalstep2
Unload FormalStep3
Unload Quickquote1
Unload Tools
End Sub
Private Sub Workbook_Open()
Dim awb As Workbook
Set awb = ActiveWorkbook
awb.Activate
Sheets("Tools").Range("A1").Value = ""
Dim usrid As String
usrid = Environ("Username")
Sheets("Data").Range("K123").Value = usrid
End Sub