+ Reply to Thread
Results 1 to 3 of 3

.Visible property not remaining true (or even becoming true) when code runs.

  1. #1
    Registered User
    Join Date
    09-04-2014
    Location
    WA, USA
    MS-Off Ver
    2007
    Posts
    69

    .Visible property not remaining true (or even becoming true) when code runs.

    Below is my code for an excel game I am making. I am having trouble with the '.Visible = true' property of labels on a worksheet. The problem with '.Visible' is a common issue in other areas of the project also. I cannot seem to get a labels to remain visible after they have been set to invisible.

    In other areas of the project, I have managed to temporarily set the label property to visible and then I had to save, exit, and reopen the workbook. This was the only mild success I've had.

    Any ideas on what is going on here? Thanks!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-04-2014
    Location
    WA, USA
    MS-Off Ver
    2007
    Posts
    69

    Re: .Visible property not remaining true (or even becoming true) when code runs.

    I apologize for the double post, but I've solved a similar problem in another area of the project that could help someone (myself or another) solve this problem here. Here is the code change I made:

    Original code:
    Please Login or Register  to view this content.
    New code:
    Please Login or Register  to view this content.
    The code now permanently makes the label visible (like I hoped). The problem was the 'Shapes' reference. Hopefully I can implement this in my other code too.

  3. #3
    Registered User
    Join Date
    09-04-2014
    Location
    WA, USA
    MS-Off Ver
    2007
    Posts
    69

    Re: .Visible property not remaining true (or even becoming true) when code runs.

    I seem to be having a conversation with myself here (which is unusual for this forum) and I apologize again for a yet another consecutive post, but I've had an important update.

    Strangely, when I implemented that new code (in an entirely different part of the game; only relation being the objects the codes affected) I noticed that the problem has been entirely solved everywhere. I am having no problems (magically, it seems) with the .Visible property being set to true; and it remains set to true until I tell it otherwise.

    Odd, but solved.

+ 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. PivotItems visible = True
    By z_eeen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2014, 12:04 PM
  2. VBA userform Textbox visible = true
    By Hilton1982 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2012, 03:19 AM
  3. [SOLVED] Complicated IF statement that runs an equation on True
    By scrumpulate in forum Excel General
    Replies: 1
    Last Post: 04-20-2012, 04:24 PM
  4. Dynamic VBA Code for PivotItems, Visible = True for "Last Month" only
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2012, 09:43 AM
  5. How to write a macro that runs until a particular cell returns TRUE
    By xiga in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2010, 09:29 PM
  6. Shapes.visible = false/true
    By Ctech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2006, 10:30 AM
  7. [SOLVED] Need a property that will give me true if a value is close
    By havocdragon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2005, 06:06 PM

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