Well, depending on how determined you are to changing this (I mean 1
seconds does get annoying, but whether it's worth maintaining what I'
about to suggest is up to you.) It is perfectly possible to have al
your forms and macros in one workbook that does not change, and th
rest of the content in another that does. What you could do is hav
the smaller workbook open the larger one automatically and call al
it’s forms and macros. Now the things that you should consider ar
these:
1 – You’ll need to put the larger file (with the macros and forms) in
relatively permanent location and if and when it gets moved you’ll nee
to update the other workbook so it knows where to find it.
2 – The code you’re using will have to be changed to make SURE they ru
with the particular workbook you want it to on top of the fact that yo
need to declare those functions as “Public” so your smaller workboo
has access to them.
3 – You’ll need to take into account whether anyone else will be makin
use of this workbook in this way and whether you or they will b
accessing it from a different computer. You’ll need to intentionall
make it flexible enough to deal with that type of situation.

So while I don’t know how to save only certain parts of a workbook (
don’t think it can be done) this would accomplish the same result i
you’re willing to spend enough time and energy to make it work. - Piku

--
Message posted from http://www.ExcelForum.com