+ Reply to Thread
Results 1 to 2 of 2

Is Hidden the Same as Not Visible?

  1. #1
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Is Hidden the Same as Not Visible?

    Hello!

    I modified the code on this page:
    http://excel.tips.net/Pages/T002025_...l_Objects.html

    so that it also shows whether each shape is visible or not:

    Please Login or Register  to view this content.

    My question is: Are "Visible" and "Not Hidden" the same thing? When I Google around, the terms Visible and Unhidden seem to be used interchangeably, but other sites treat them as two different properties.

    (For my macro, I want to test for all hiddenness/visibility, so is the Visible= False all I need, or do I also need to also test for Hidden=False?)

    Thanks for the help!

    VR/Lost

  2. #2
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    365
    Posts
    1,256

    Re: Is Hidden the Same as Not Visible?

    Shapes have a Visible property but they don't have a Hidden property.
    Ranges have a Hidden property but they don't have a Visible property.

    So, you can't use the Hidden property in your example.

    In terms of nomenclature distinction, here's a previous discussion on this:
    http://www.excelforum.com/the-water-...roperties.html
    Hope that helps,

    Colin

    RAD Excel Blog

+ 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