I have a table that contains (50) selections. In the past, I would have the
user type in a lower case "x" in the cell next to the selection to activate a
macro to un hide a section of the form. This time, I would like the user to
make a left mouse click the cell next to the selection they want to both
activate a macro to unhide the section and enter a lower case "x" in the box
they just left clicked on. The macro is already created and just needs to be
connected to the mouse click. Any help would be appreciated. Thank You, JAD

right click sheet tabview codeleft window worksheetright window RIGHT
click or DOUBLE click

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JAD" wrote in message
...
I have a table that contains (50) selections. In the past, I would have the
user type in a lower case "x" in the cell next to the selection to
activate a
macro to un hide a section of the form. This time, I would like the user
to
make a left mouse click the cell next to the selection they want to both
activate a macro to unhide the section and enter a lower case "x" in the
box
they just left clicked on. The macro is already created and just needs to
be
connected to the mouse click. Any help would be appreciated. Thank You,
JAD

Pick a cell and:

Insert Hyperlink to a place in this document same cell

So clicking on this hyperlink just takes back to itself (you don't really
jump at all)

In the worksheet code area:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
ActiveCell.Value = "x"
Call AlreadyExists
End Sub

where AlreadyExists is the current macro.


--
Gary''s Student - gsnu200799


"JAD" wrote:

I have a table that contains (50) selections. In the past, I would have the
user type in a lower case "x" in the cell next to the selection to activate a
macro to un hide a section of the form. This time, I would like the user to
make a left mouse click the cell next to the selection they want to both
activate a macro to unhide the section and enter a lower case "x" in the box
they just left clicked on. The macro is already created and just needs to be
connected to the mouse click. Any help would be appreciated. Thank You, JAD