Charles Williams Wrote:[color=blue]
AFAIK you wont get any fewer temp files with Forms controls unless you
have
fewer controls.

But since i find it hard to imagine a sensible menu with 160 different
commands I would assume that a lot of the buttons are basically the
same but
maybe need to know what sheet is active:
so my advice would be to convert all the code to an XLA with its own
menu
and/or toolbar and/or formas and you probably only have 10-30 items on
the
menu.

regards
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Dave Peterson" wrote in message
...


That's where I started, but I couldn't come up with a way to
differentiate between the three different types of sheets the file
requires with 100% confidence. My compromise was to put only the
controls needed for each type of sheet on the appropriate sheet. Right
now, the problem is that copies of this file have proliferated out to
almost a dozen users with 1-10 copies per user, so trying to pull them
all in and modify them is out of the question (I'd rather have one of
our support people write a cleanup script and run it on a scheduled
basis).


--
FrankB
------------------------------------------------------------------------
FrankB's Profile: http://www.excelforum.com/member.php...o&userid=18952
View this thread: http://www.excelforum.com/showthread...hreadid=480679