Compact Excel Spreadsheet

[Newbie]

Is there a way to compact a spreadsheet that seems to have grown out of all
proportion since I have added code.

Like in Access?

Thanks

 

[Ron de Bruin]

Hi Newbie

Don't save the file in two versions but only as Microsoft excel workbook
Not as 97-2002 & 5.0/95 workbook(this make your workbook big)

You can use Rob Bovey's Code cleaner to clean up your code
http://www.appspro.com/utilities/utilities.asp

See Debra's site for cheking your Usedrange
http://www.contextures.com/xlfaqApp.html#Unused