Hi,
I have an index sheet with buttons that I want to have such that when each
button is clicked it goes to a specific worksheet within the file and for
that I have brought a list of all sheet names in that index tab. I would like
to have the button names linked to the respective cells that contain the
names of the tabs so that if I change the tab names the buttons automtically
update.
Can anyone help me with how I link the button name (caption) to a cell?
Thanks in advance.
Neda