Results 1 to 3 of 3
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Form caption (xl2000)

    I am using a Form initialise event to hide the close [x] button.
    The routine I use to trigger display of the Form sets a number of the Forms contents before using the Formxxx.Show
    This works OK.
    However, on another Form (without the close [x] button) I want to use the Form.Caption to display the contents of a cell.
    When I do this, the close [x] button appears.
    Is there a way of triggerring the Form initialise event again AFTER setting the variable Form caption???

    zeddy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form caption (xl2000)

    Create a separate routine procedure to hide the close button. Call this procedure in the Form_Initialize event AND in the routine that sets the form caption.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: Form caption (xl2000)

    I bow to your expertise.
    Works a treat.

    Many many thanks!

    zeddy

Posting Permissions

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