PDA

View Full Version : Stop userform from loading



lawsonbooth
06-25-2007, 01:48 PM
I am preparing a report in workbook1 and I need to open workbook2 to get some data and then close workbook2. Workbook2 has a userform loading upon opening. Is there a way to stop the userform from loading in workbook2 when being openned by another workbook? It stops my processing in workbook1 until I close the userform in workbook2.:banghead:

mdmackillop
06-25-2007, 02:27 PM
Application.EnableEvents = False

lawsonbooth
06-25-2007, 03:35 PM
Thank you for the help!