View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Compact Excel Spreadsheet

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




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Newbie" wrote in message ...
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