Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unloading a Macro (2000)

    In my macro, when the user "quits" the tool, I simply Me.Hide the form. Is there a way, or should I even, unload the macro completely from memory? Or is Hiding the form sufficient.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Unloading a Macro (2000)

    Me.Hide just renders th euserform invisible, but all values, properties etc remain intact and so consume resources. Once you have no further need for the form you can zap it with Unload Me from within the userform's own code pane or Unload UserFormX from a general module.

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •