Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 -------------------------------------------------------------- Any glaring reason why they could be hanging? I currently do not know their OS or Excel version, I've asked them to provide it. Any help is appreciatable. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
Error when user clicks "no" | Excel Programming | |||
"Enable, Disable macros" window does not pop up, security is medi | Excel Programming | |||
Excel 2004 for Mac freezes if I enable "drawing" toolbar | Excel Discussion (Misc queries) | |||
Code to ignore on-screen message concerning "Enable Macros." | Excel Programming |