James - that is good advice. My users will be adding data within the
workbook, either via a form or directly within a worksheet. Maybe I can work
some type of import process into the workbook thereby giving the user the
ability to import their data into updated versions. This gives me something
to think about.

thanks, mike

"jamescox" wrote:


Well, we'll test your bold statement that any advice will be
appreciated! :Bgr

It's not clear what your users will be doing with the workbooks -
whether they will be addiing data on some worksheets, or adding formulas
on worksheets or adding new worksheets.

From what you did say, I'd almost suggest flipping your contemplated
approach around. Instead of sending them a worksheet they will have to
modify and incorporate into their existing version of the workbook,
would it be possible to restrict their customizations to a few
worksheets and have them copy those custom worksheets into the next
version workbook?

Again, not being sure what the users are doing with the workbooks this
may be a totally impossible suggestion, but at least you didn't pay a
lot for it! I'd appreciate hearing what you finally decide to do on
this.

James

PS - doing it this way would avoid the issue of having the end-user
over-writing / replacing code modules...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112076