Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashes on close
I have several workbooks that contain different macros for various purposes.
These workbooks dont need to be saved after use. I originaly was using "Application.DisplayAlerts = False" & "Workbooks.Close" to not show the save msg and then just close the work book. All this is done in the workbook module under beforeclose. I've did some searching around and tried useing a timer to give it time to think and also tried "Workbooks("Home-Item Lookup.XLS").Close SaveChanges:=False" without luck. Either it asks me to save the workbook (which i would perfer not as the workbooks are blank templates designed to pull further info. based upon filled in cells.), or the workbook closes but then excel itself crashes. I do have shapes in the workbook but none of the shapre have anything to do with the book closeing. Any ideas on this i could try or something im missing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes on "Close" Visual Basic error 400 | Excel Discussion (Misc queries) | |||
Repost Excel Crashes on Workbook close!! | Excel Programming | |||
Excel 2003 crashes when I close any worksheet | Excel Discussion (Misc queries) | |||
Excel crashes on close - macro related | Excel Programming | |||
Excel crashes with .Close command | Excel Programming |