The only query i have is with the 2nd option. If i insert a ? clipart or gif for someone to click on, how can i bring up a message box from that? I could use a hyperlink to another sheet or cell somewhere but then the user will have to find their way back again.
Activex is out because this will be used on a corporate network where they don't like that kind of thing.
I have a shape which is a button that runs a macro but i want to add a comment to explain what it does before the button is clicked on.
Is it possible to have a text message pop up when you mouseover a shape?
Sub ShowHelpInvItems()If Sheet7.Range("J1").Value = "Show Help" Then
Sheet7.Shapes("HelpPopUpsGrp").Visible = True
Sheet7.Range("J1").Value = "Hide Help"
Else:
Sheet7.Shapes("HelpPopUpsGrp").Visible = False
Sheet7.Range("J1").Value = "Show Help"
End If
End Sub
Sub ShowHelpSetupScrn()
If Sheet1.Range("AF2").Value = "Show Help" Then
Sheet1.Shapes("HelpPopUpsGrp").Visible = True
Sheet1.Range("AF2").Value = "Hide Help"
Else:
Sheet1.Shapes("HelpPopUpsGrp").Visible = False
Sheet1.Range("AF2").Value = "Show Help"
End If
End Sub