Macros and Virtual Memory

[broadpipe]

I have a BIG problem....i have created a spreadsheet which contains about 40 sheets which each contains about 30 checkboxes which interlink to produce a form.

When I open it the PC returns the error of 'Out of Virtual Memory'....

Apparently after speaking to my Tech friends the macros seems to be using 200MB ....can someone explain how this can happen and if I can solve the problem without reducing the number of macros and VBA

 

[NikNik]

is replacing the checkboxes with cells where the user can enter an x an option - it sounds like it is the controls that are hogging the memory?

 

[XL-Dennis]

broadpipe,

First of all 40 x 30 = 1200 :wink:

If You´re using checkboxes from the Control Commandbar then replace them with checkboxes from the commandbar Forms.

How many macros does the workbook include and is it possible to reduce the number of macros?

HTH,
Dennis