• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

show hide help

camrose

New Member
UPDATE! nevermind I found the link.

For anyone else who may stumble across this and need help:

http://chandoo.org/wp/2012/04/26/adding-macros-customer-service-dashboard/


Hi there,

I'm new to the forum and I am trying to figure out the below macro:


Sub showHideHelp()

' showHideHelp Macro

ActiveSheet.Shapes.Range(Array("boxHelp")).Visible = Not ActiveSheet.Shapes.Range(Array("boxHelp")).Visible

[valHelpStatus] = ActiveSheet.Shapes.Range(Array("boxHelp")).Visible

End Sub


is there a text box named "boxHelp" How do I rename the shape?


Thanks in advance for any help you can provide.


Cameron
 
Back
Top