Try using hyperlinks. No VBA needed.

Best wishes Harald

"Isis" wrote in message
...
I have a Workbook full of worksheets with bank account details - the first
sheet is an Index sheet with a summary of the various accounts
worksheets -
I want to select the appropriate worksheet and display it when I click (or
maybe double click) the account name on the Index sheet - can I do that ?

Thanks