Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to Close File
I added some code in an Excel file that told me whether I was done with the
active sheet or not. Basically, if I entered all the information I needed, the tab colour would be green. Otherwise, it would be red. I used a Workbook_SheetChange event and called a module that had the code. Upon closing the file, I got prompted to save. I clicked Yes, it saved, and reprompted me to save endlessly. Basically, the code for the colour change was this: ActiveSheet.Tab.Color = RGB (Insert colour code) When I go to save, the Saved property is false. I have since taken the colour code out, and it works fine. What am I missing? I would really like this to work, as it is very handy as opposed to going to my Summary tab to see what tabs need info. TIA. -- I am running on Office 2003, unless otherwise stated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Everytime i close an excel file, it creates a new backup file | Excel Discussion (Misc queries) | |||
Close & save a file at set time only IF the file is open | Excel Programming | |||
Close file and run macro from newly opened file | Excel Programming | |||
VBA - on a button event, open another closed file, post changes, close file | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming |