+ Reply to Thread
Results 1 to 2 of 2

Userform Border Issue Windows 7

  1. #1
    Registered User
    Join Date
    12-05-2014
    Location
    missouri
    MS-Off Ver
    2010
    Posts
    2

    Userform Border Issue Windows 7

    I have a Userform that holds a button and what i would like it to do is for the form to be transparent except for this button. More buttons may be added in the future.
    As of right now the Userform actually does go transparent, it also removes the Close button however windows 7 seems to interfere with the transparency.

    Windows 7 and newer has a setting called PaddedBorderWidth and it puts a border around all the forms. Its value can only be read by VBA and is really the cause of my issue.


    I would like to get rid of this border. If it comes down to it i could settle for either resizing the border or if i could possibly color it.

    transparentform.png
    You should be able to copy and paste the code.
    Please Login or Register  to view this content.
    Last edited by ttyler333; 12-06-2014 at 06:32 AM. Reason: Fixing my code.

  2. #2
    Registered User
    Join Date
    12-05-2014
    Location
    missouri
    MS-Off Ver
    2010
    Posts
    2

    Re: Userform Border Issue Windows 7

    http://www.excelforum.com/excel-prog...ml#post3750470 I found the answer to my problem with the code that was posted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 09-06-2013, 02:17 PM
  2. Page break border issue
    By chaddug in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2013, 11:34 AM
  3. Windows 7 :Issue with Exel VBA in Window 7
    By guanqiao in forum Microsoft Windows Help
    Replies: 3
    Last Post: 10-09-2012, 02:31 PM
  4. Border color issue in Excel 2003
    By d3hartm2 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-07-2009, 02:26 PM
  5. Remove the blue-window border on modeless userform?
    By Dr.Ile in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2007, 03:50 AM

Tags for this Thread

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