View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Manisha[_3_] Manisha[_3_] is offline
external usenet poster
 
Posts: 1
Default Excel2000 VBA - Workbook size increases abnormally.

Hi!

I am using macro (VBA Project) in Excel 2000.

The macro just records the old value and new value of a cell on chang
and stores it in another sheet. The macro is Digitally Signed.

When I type data in few cells and save workbook, the size of th
workbook increases abnormally - almost doubled.

After saving 4-5 times, it goes into MBs (upto 64 MB or more). Then th
workbook is non-accessible giving not enough memory error. (Please not
that the data is entered hardly in 7-8 cells).

Is this due to macro virus? (I have read about macro virus pdlt/Larou
for Excel 97. Also, there is tool to remove this virus for Excel 97 o
microsoft site. But not for Excel 2000)

Please help...Thanks

--
Message posted from http://www.ExcelForum.com