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.

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

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

Originally Posted by fredlo2010

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

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

Originally Posted by fredlo2010

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

You are welcome. I am glad to help