Roopher
Board Regular
- Joined
- Jul 8, 2008
- Messages
- 73
Hello there!
I have an application (Excel 2007, VBA) that contains some Change_Events on Listboxes on the worksheet. There events work fine when the workbook is open.
However, when I just open the workbook, I get 'Compile Error' messages in these Event-Handler procedures. I guess, it is so because the Change-Event triggers when the 'targets', i.e. the Listbox, are not fully loaded/populated/not readily built.
Is there a way to delay or disable Excel's macro compilation when opening the workbook until all listbox elements are properly populated? Or, can I disable/enable the event procedures?
I also have an 'Workbook Open' event with 'Application.EnableEvents = False/True', but no relief from this as the above mentioned change events seem to fire earlier.
Thank's alot,
I have an application (Excel 2007, VBA) that contains some Change_Events on Listboxes on the worksheet. There events work fine when the workbook is open.
However, when I just open the workbook, I get 'Compile Error' messages in these Event-Handler procedures. I guess, it is so because the Change-Event triggers when the 'targets', i.e. the Listbox, are not fully loaded/populated/not readily built.
Is there a way to delay or disable Excel's macro compilation when opening the workbook until all listbox elements are properly populated? Or, can I disable/enable the event procedures?
I also have an 'Workbook Open' event with 'Application.EnableEvents = False/True', but no relief from this as the above mentioned change events seem to fire earlier.
Thank's alot,