Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PSERSONAL.XLS macro book
I have some very strange behaviour in my PERSONAL.XLS book (Excel 2003,
Office XP). It is normally about 1mb in size. These days whenever I do some work on it (including DELETING lines) it will suddenly jump to over 2mb in size for no apparent reason. If I then copy all the modules to another workbook, delete all the PERSONAL modules and then copy them back it goes back to it's former (or newly reduced) size. Then after a little more work it will jump to over 2mb again, and I have to repeat the process. I'm trying to keep the size as slim as possible because the autosaves take too long otherwise. I thought that there may be some problem with the book itself so I tried to save another file as the PERSONAL.xls. This works (don't know about any size jumping) but the new book is always displayed as an open workbook, whereas PERSONAL.XLS does not). Is there a way to stop this displaying or does the original PERSONAL having some special properties? Does anyone have any idea why the book will suddenly double in size please? Regards, Brett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for work book | Charts and Charting in Excel | |||
Keeping a Macro in a new book | Excel Worksheet Functions | |||
Keeping a Macro in a New Book | Excel Programming | |||
Executing macro in one book from another. | Excel Discussion (Misc queries) | |||
Best excel macro (vba) book currently ? | Excel Programming |