Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Office 2003 and Win XP;
I have a normal XLS file which runs hidden (Window-Hide). This file is run from a toolbar. This hidden file does things to other files from the toolbar and in the process some data gets written into the hidden file, but it is only needed temporarily. The hidden file is shared, so it is set to open read only by default using file properties. Apparently, it is not possible to code this file so when a user closes MS-Excel the hidden file will close itself without warnings, without messages, and without saving? i.e. just drop dead, quietly? I have tried all manner of the following in either and both the Before_Close and Before_Save events: Cancel = True Application.EnableEvents = False Application.DisplayAlerts = False ThisWorkbook.Saved = True ThisWorkbook.Close SaveChanges:= False No matter what I try, I ALWAYS get the save file question. If not impossible, please tell me how it can be done. Thanks much in advance from a very frustrated user. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MATCH/IF/OR/AND statements not what I need apparently | Excel Discussion (Misc queries) | |||
Apparently missing in Excel 2007 | Excel Discussion (Misc queries) | |||
I need help with a (apparently) very simple VBA script | Excel Programming | |||
My needs are simple-apparently, so am I | Excel Worksheet Functions | |||
Apparently Simple Question | Excel Programming |