macro linked to text in a cell

[northernstar197]

hi

i would like any suggestions on the following please

i have names in a matrix going across the columns and i would like to attach a macro to these names/cells.....is this possible

the macro would hide and show worksheets in the workbook

thanks

[Bryan Hessey]

hi

i would like any suggestions on the following please

i have names in a matrix going across the columns and i would like to attach a macro to these names/cells.....is this possible

the macro would hide and show worksheets in the workbook

thanks

Hi,

little bit late for tonight, but the attached works on double-click a cell in the A column, the code could be modified to alternately Hide / UnHide the sheetname that was in the cell.

Is that the sort of idea you were looking for?

---

[northernstar197]

sorry for the delay

thanks for your reply and yes it was very helpful and i have now edited the code to hide and unhide where i needed to!!!

thanks again

[Bryan Hessey]

sorry for the delay

thanks for your reply and yes it was very helpful and i have now edited the code to hide and unhide where i needed to!!!

thanks again

Ok - good to see and thanks for your response.

---