Not sure if VBA can use Control Arrays, but write a control array for the
buttons, maybe? And code it so they won't show up until they are needed? I
know it can be done in VB somehow, just not the actual execution of it.
Also, you could try writing the same code in VB (if you have it) and see
what the file size is there. If it's smaller and the other computer(s)
already has/have Excel, you might think of using OLE through VB instead of
strict VBA. Of course, that's a moot point if you don't have VB ....
Ken
un*****@hotmail.nospam.com
"Tom Wright" <tj*@wherever.com> wrote in message
news:i6********************************@4ax.com...
steve,
regretfully, Save As does not seem to be the ultimate solution. within
the last couple of days i've seen my save size vary randomly from 475k
to 950k even though i've been making no changes that should materially
affect the size. Save As took my current version from 657k to 655k,
quite far above 475k.
anyone have any further ideas?
tom
On Tue, 27 Jan 2004 18:25:18 -0800, "Steve Gerrard"
<no*************@comcast.net> wrote:
"Tom Wright" <tj*@wherever.com> wrote in message
news:ic********************************@4ax.com.. . i have an excel spreadsheet with embedded vb. it's amazingly huge
(600k to 900k).
as i put in minor edits to the code or forms, it gets bigger very
fast. for example, i added 2 buttons and about 5 lines of code for
each (copied from elsewhere in the program) and it grew by 50k! i
added a tab to a dialog element and moved a couple of controls from
one tab to another and it grew by 100k!
occasionally i'll make some tiny change ant it will shrink by 300k. i
assume it's done some cleanup or compress operation.
is there a way to force this cleanup when i want it so i can get the
smaller version for distribution?
thanks,
tom
san diego
Save As.
900k no longer seems "amazingly huge" to me. It seems like all MS files
are big these days...