How do I get Excel to save the data in a worksheet and not the VB

C

Chris

I have a project that I am working on. The file size has become very big due
to the amount of coding involved. All I want to do is save the data in the
worksheets but nothing else as that stays the same. Cant see any point saving
it time after time. Saving the file is taking a while and I want to cut down
on the amount of time taken.
 
B

Beth Melton

You should place VBA code or place it in another workbook and either
open it when you need the code or if you need it for most of your
workbooks then either use the Personal.xls workbook or place another
workbook in your XLStart folder. If you save the workbook while it is
a hidden window it will load when Excel starts but will not be visible
on the screen.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top