Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm wondering if this is a bug, or if I should have known this; I just
verified that when I open an .xla file (not adding it as an addin using Excel, just doubleclicking right on it to open it) and make changes in the VBA editor, when I close it it doesn't prompt to save changes, and it doesn't save the changes. I have to remember to save. This ALSO happens when I have it in the workbook as an Add-In. if I make changes in the vba editor, then close the editor, no prompt. Then saving the workbook doesn't save the vba changes either. I found this out by losing about 15 hours of work. I know I'm not a high-level programmer, but I thought I was beyond this kind of mistake. None of my code has anything about turning off warnings or save prompts, I had one bit that turned off screenupdating, but even if I interruped some code, that being off wouldn't losr my save promots, right? I get save prompts when I close a Workbook. Is this by design? That I can work for 15 hours in the Excel vba editor, and get no save and no prompt to save when I close it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
prompt user to save file as {desired_name} and save it to a variab | Excel Programming | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
Customized VBA Editor Format Save Location | Excel Programming | |||
Prompt to save changes | Excel Programming | |||
Save As... prompt | Excel Programming |