How do I Prevent file size from getting larger and crashing?

alanuzi

New Member
Joined
Dec 12, 2005
Messages
3
Hi

Can anyone help....

I've put a userform in excel which interacts with some tables on the worksheets, the form loads on initialize, the file is about 600KB.

The problem is that i can load the form fine the first time i run it, then i save it and it adds 70 KB to the file, and wont open again!!!! (it just errors and excel crashes)

But..

if i disable the macros and just open the userform and macro in VBA editor then save and exit, it reduces the file and will run again!!! :devilish:

If anyone has any ideas about this then please let me know.


thanks :biggrin:

alanuzi
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

alanuzi

New Member
Joined
Dec 12, 2005
Messages
3
i removed the multipage that i was using on the form and create 4 other forms instead, this seems to have done the trick,

alanuzi
 

Watch MrExcel Video

Forum statistics

Threads
1,118,820
Messages
5,574,511
Members
412,599
Latest member
Schu94
Top