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
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