Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Size of Excel workbook

Hi!

I am using VBA project in Excel 2000 to track the changes in the worksheet. The macro just stores the old value of the cell (value prior to change) and the new value (changed value) in a hidden and protected sheet. The code is having Digital Signature.

When I run macro (Enable macros), type data in some of the cells and save the workbook, the size of the workbook increases - almost doubled. After saving 4-5 times, it goes into MBs. Then the workbook is non-accessible giving not enough memory error.

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

Please help...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Increase in the Size of the Excel WorkBook Sagu Excel Discussion (Misc queries) 1 January 19th 07 11:56 PM
can i size an Excel workbook window's opening size? ncjenny Excel Discussion (Misc queries) 0 November 12th 06 04:03 PM
Excel Workbook file increaseing in size Woody Excel Discussion (Misc queries) 0 March 27th 06 06:47 PM
why does my excel workbook keep doubling in size? COWGIRL Excel Discussion (Misc queries) 1 May 13th 05 01:50 AM
Any tips to reduce excel workbook size? Troy Emery Excel Discussion (Misc queries) 6 May 12th 05 07:10 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"