View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How can I reduce the Size?

Your used range on sheets may be larger than you think.

See Debra Dalglesih's site for help on resetting.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP


On Tue, 23 Nov 2004 16:33:19 -0600, 0000_AAAA_0000
wrote:


Hi, and Many Thanks in advance!


I have got one excel workbook, with a few modules , a few shapes a few
buttons etc.
But the Workbook Size is too big, and actually just sending a copy of
the same worksheet to a new workbook and then inporting the first
workbook modules to the new one I can reduce the size by a half.

What's going on?
Is it normal a workbook with 564K, with just 2 worksheets, 15 shapes,
10 buttons and 2 modules, with no more than 300lines of code in both
modules?

Am I doing anything WRONG?

THANKS!