Nothing that allows you to separate the code from the worksheets in a single
workbook.

But have you thought about separating your code from your workbook?

You could create a toolbar that runs your macros against the active workbook.
Then you save just the workbook with the data.



opiec wrote:

Hi,

I've written an application that will be used to drive a local
wrestling tournament. I have quit a bit of VB code with many macros.
The problem is the worksheet takes way too long to save. The people
running the tournament will be constantly going in and out of several
worksheets (files) and it's real painful to wait around 20 seconds to
save each file after simply updating a cell or two.

Is there a way to write a special "save" macro that saves only the data
in the cells and not the many macros that I have?

Thanks for your help!

--
opiec
------------------------------------------------------------------------
opiec's Profile: http://www.excelforum.com/member.php...fo&userid=4963
View this thread: http://www.excelforum.com/showthread...hreadid=275999

--

Dave Peterson