tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
So heres the situation,
I have two shapes
one to called Hide12
the other called Unhide12
i want a macro to identify the shapes name simply by the fact i clicked it,
then use a macro that says.
clicked shape hide,
other shape unhide
OK let me make this clearer,
on my page all my shapes are called either "Hide" or "Unhide" followed by a number for example Hide1 matches Unhide1 etc
i want a macro that i can assinge to all these shapes that says this
Get the Clicked shapes name,
if name starts with "Un" the "Hide" + (number on end of name) visible "Unhide" hidden
so i hide one shape show the other
can this be done?
thanks
Tony
So heres the situation,
I have two shapes
one to called Hide12
the other called Unhide12
i want a macro to identify the shapes name simply by the fact i clicked it,
then use a macro that says.
clicked shape hide,
other shape unhide
OK let me make this clearer,
on my page all my shapes are called either "Hide" or "Unhide" followed by a number for example Hide1 matches Unhide1 etc
i want a macro that i can assinge to all these shapes that says this
Get the Clicked shapes name,
if name starts with "Un" the "Hide" + (number on end of name) visible "Unhide" hidden
so i hide one shape show the other
can this be done?
thanks
Tony