I have a workbook with about 35 worksheets. I have input fields spread
throughout these sheets of about 100 fields. THe workbook is becoming
too large to save each instance values change and need to be recalled.
I created a new sheet that has links to all the inputs.

What I would like to do is save this one sheet and the values (not
links) and be able to reload it using a macro. All the values can be
plain text. If saved in an excel format, I would also like to change
the sheet name so when it is reloaded, I don't have a problem with the
original sheet.

Any help would be greatly appreciated.


--
Bruce001
------------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...o&userid=26630
View this thread: http://www.excelforum.com/showthread...hreadid=483161