Cell Click Event

[bobgodfrey]

On a cell click event how can I run a macro that will unhide a worksheet and name it? These are my requirements:
if any cell in H2 - H10 is clicked
unhide the Sheet called Blank
Rename the Sheet to the corresponding value in A (example if H2 is clicked the worksheet should be named Bob, if H3 is clicked the worksheet should be named Joe)

Attached is a sample workbook that shows data structure.

[spitfireblue]

Try this:

Please Login or Register  to view this content.