+ Reply to Thread
Results 1 to 3 of 3

Remove the blue-window border on modeless userform?

  1. #1
    Registered User
    Join Date
    11-02-2004
    Location
    Slovenia, LJ
    MS-Off Ver
    2007
    Posts
    40

    Remove the blue-window border on modeless userform?

    Hi all,

    I am trying to remove the blue-window border and bar (where the caption is put, and the red close cross 'x') from a modeless userform, so that it looks like a standard label on a sheet.
    Does anyone know a statement or property?

    Thanx

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Dr.Ile,

    The is no method or property to remove the Window's title bar. To do so requires a macro using API calls. Add a Standard VBA module to your Workbook, and then copy the macro code below and paste it into the module.

    Please Login or Register  to view this content.
    Using the Macro:

    Place the macro "RemoveTitleBar" in the UserForm's Activate event procedure to remove the caption when the UserForm is shown.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    11-02-2004
    Location
    Slovenia, LJ
    MS-Off Ver
    2007
    Posts
    40
    Thank you Ross, you save me from ineffective searching for applicable method or property. I never thought of API and most of all, I'm not familiar with it.

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1