Hi Guys,
I'm looking for a macro to link to a button.
When pushed once it will display a number of shapes on the sheet (containing text) when pressed again it will hide these shapes.
The aim is to produce a 'help' button which will call up annotations explaining to the user what parts of the sheet do etc.
Many thanks for any help!
Last edited by freud1; 04-20-2010 at 05:24 AM.
Something like this, we only check the "hidden" status of one of the shapes, if it is visible, we make the whole list of shapes invisible, and vice versa.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JBeau! what an ideal solution.
Worked first time!
One day i can only hope to know Excel as well as you do!
Many Many Many thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks