daveatthewell
New Member
- Joined
- Jul 28, 2006
- Messages
- 43
I've got a problem with userforms and the workbook open event.
here's a snippet of code from the open event
Private Sub Workbook_Open()
Dim User As String
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = False
Load QQLog
Now QQLog is the Name (in properties) of the userform which I want to load then show modal, awaiting input into various combos, text boxes etc.
Trouble is sometimes the workbook opens and displays the form (normally when I've not got VB active (Alt F11)) without a problem and sometimes I get a file/path error. Then Excel crashes with a Send report dialog folowed by a recovery if that option is checked. The repaired version more often than not, excludes the form ... and any other code.
It's the intermittent nature that annoys me, sometimers it's ok, mostly it's not.
Any offers?
TIA
DK
here's a snippet of code from the open event
Private Sub Workbook_Open()
Dim User As String
Application.Calculation = xlCalculationAutomatic
Application.DisplayAlerts = False
Load QQLog
Now QQLog is the Name (in properties) of the userform which I want to load then show modal, awaiting input into various combos, text boxes etc.
Trouble is sometimes the workbook opens and displays the form (normally when I've not got VB active (Alt F11)) without a problem and sometimes I get a file/path error. Then Excel crashes with a Send report dialog folowed by a recovery if that option is checked. The repaired version more often than not, excludes the form ... and any other code.
It's the intermittent nature that annoys me, sometimers it's ok, mostly it's not.
Any offers?
TIA
DK