Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
I have written an workbook with its own custom toolbar. I have attached the workbook to task schedule and it runs every 5 minutes. No issues. However, I have recently noticed that everytime the workbook opens/closes, my XLB file increases in size by 3KB each time. As you can image, the XLB file can become extremely large in month. I know I can delete XLB and "start over", however, I was planning on giving the macro workbook to others and I didn't want to have to remember to "clean up" their XLB every month. I tested the opening and closing of Excel (NOT using my macro workbook) and it increases the XLB by 1KB every 3 or 4 times a workbook is open. Is there some kind of newbie thing I did when writing my macro or creating my custom toolbar that is increasing the XLB so quickly? In my macro, I do "test" upon opening of the macro workbook to see if my custom toolbar exists (and if it does not, I create it) and then the "auto open macro" attaches the proper macro to the individual custom toolbar icons. Any help would be greatly appreciated. MSweetG222 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to increase size of image in button (msocontrolbutton) of custom toolbar of Excel | Excel Discussion (Misc queries) | |||
How to increase size of image in button (msocontrolbutton) of custom toolbar of Excel 2000 | Excel Programming | |||
how to increase size of button's image of custom toolbar of Excel | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
Size of custom toolbar | Excel Programming |