| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with Workbook_BeforeClose event
ps. I still wouldn't do this <vbg.
Bob wrote: Thanks for your help! I really appreciate it. BTW, if I can impose on you one more time, can you tell me the difference between using ActiveWorkbook.Close True versus using ThisWorkbook.Save? Thanks again. Regards, Bob "FSt1" wrote: hi Private Sub Workbook_BeforeClose(Cancel As Boolean) 'some code here ActiveWorkbook.Close True '************** End Sub when you run code on the before close event, that triggers excel into thinking something as changed therefore you need to save the book. again. so you will have to resave the workbook . the above does that automaticly. no extra clicking on extra popups. regards FSt1 "Bob" wrote: Forgive me, I should have said, "Is there some code I can add to the Workbook_BeforeClose event that will auto-save the workbook when I Close it?" "Bob" wrote: After I Save a workbook, I then Close it. But when I do so, Excel prompts me to Save the workbook again. Is there some code I can add to the Workbook_BeforeClose event that will negate the prompt to re-save it (even after I just Saved it!)? Thanks in advance for any help. Bob -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook_BeforeClose Event (help!) | Excel Programming | |||
| Problem with Workbook_BeforeClose event | Excel Programming | |||
| Workbook_BeforeClose event is not canceled | Excel Programming | |||
| Workbook_Beforeclose vs BeforeClose Event | Excel Programming | |||
| Workbook_BeforeClose Event | Excel Programming | |||
Hybrid Mode
