+ Reply to Thread
Results 1 to 5 of 5

need to change shape color if certain rows hidden!!!

  1. #1
    Registered User
    Join Date
    09-24-2011
    Location
    Yemen
    MS-Off Ver
    365
    Posts
    77

    need to change shape color if certain rows hidden!!!

    i have four shapes in one page need to change shape or button color to red if it made certain rows hidden
    if it is not hidden remain original color
    hope to understand what i mean ..thanks in advance

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: need to change shape color if certain rows hidden!!!

    Hi Try this

    In the sheet enter this procedure. This is a general procedure that will work with any of your buttons/shapes
    Please Login or Register  to view this content.
    Now, to use it just like this:
    Please Login or Register  to view this content.

    Hope this helps

    Thanks

  3. #3
    Registered User
    Join Date
    09-24-2011
    Location
    Yemen
    MS-Off Ver
    365
    Posts
    77

    Re: need to change shape color if certain rows hidden!!!

    damn its working ,u r amazing
    great i can call procedure for any button on any page
    I really appreciate your help
    thanks for your time
    Quote Originally Posted by fredlo2010 View Post
    Hi Try this

    In the sheet enter this procedure. This is a general procedure that will work with any of your buttons/shapes
    Please Login or Register  to view this content.
    Now, to use it just like this:
    Please Login or Register  to view this content.

    Hope this helps

    Thanks

  4. #4
    Registered User
    Join Date
    09-24-2011
    Location
    Yemen
    MS-Off Ver
    365
    Posts
    77

    Re: need to change shape color if certain rows hidden!!!

    damn its working ,u r amazing
    great i can call procedure for any button on any page
    I really appreciate your help
    thanks for your time
    Quote Originally Posted by fredlo2010 View Post
    Hi Try this

    In the sheet enter this procedure. This is a general procedure that will work with any of your buttons/shapes
    Please Login or Register  to view this content.
    Now, to use it just like this:
    Please Login or Register  to view this content.

    Hope this helps

    Thanks

  5. #5
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: need to change shape color if certain rows hidden!!!

    You are welcome. I am glad to help

+ 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. Change color of shape with vba
    By ahmadyan63 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2014, 04:14 PM
  2. Change color of shape depending on value
    By bongielondy in forum Excel General
    Replies: 1
    Last Post: 08-27-2014, 09:56 AM
  3. Change color of shape depending on value
    By bongielondy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2014, 07:03 AM
  4. Add command button to shape and change shape color on mouseover
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-26-2012, 05:12 PM
  5. Can a macro change the color of a shape?
    By ditisFloris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2010, 08:21 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