xlb size and addin with custom toolbar
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
|