Close form instead of hide
 

Hello folks,

I have a spreadsheet with 12 forms on it which are all accessed from an
opening UI. Once opened the form is taking up memory I presume and when
I get rid of the form with the objet.hide method it is still in
memory?

Is there a better way? I can't find a "Close" method which applies to a
form. I'm running Excel 97.

Any suggestions welcome!


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=470898

Close form instead of hide
 

Hi

You can use Unload Me

See also
http://support.microsoft.com/default...b;EN-US;829070


--
Regards Ron de Bruin
http://www.rondebruin.nl


"skuzapo" wrote in message
...

Hello folks,

I have a spreadsheet with 12 forms on it which are all accessed from an
opening UI. Once opened the form is taking up memory I presume and when
I get rid of the form with the objet.hide method it is still in
memory?

Is there a better way? I can't find a "Close" method which applies to a
form. I'm running Excel 97.

Any suggestions welcome!


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=470898

Close form instead of hide
 

Hi Ron - thanks for the info and the excellent link.
Cheers


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=470898