Excel crashes on close

M

Mr. m0le

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?
 
J

JLGWhiz

Try it this way:

"Workbooks("Home-Item Lookup.XLS").Saved = True
"Workbooks("Home-Item Lookup.XLS").Close
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba code does not run 3
Close a workbook 4
Save workbook without shapes 0
Excel crashes and restarts when accessing newly created worksheet 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
populate a combobox based on unique values in another workbook 16
Open four Wbooks, copy four columns from each to Master Wbook 16
explicitly name workbook and close without saving 2

Top