Click on 1 cell to goto another worksheet

**luffield** · 05-22-2009, 10:09 AM

Hi All,

Apologies if this has already been done but I cannot find it.

I am trying to click one 1 cell, which will automatically use a lookup of the cell values and find the correct sheet to go to.
All of this using VBA.

I have attached an example

Thanks

**Andy Pope** · 05-22-2009, 10:56 AM

can you tell us which cells should react to being clicked

**luffield** · 05-22-2009, 10:57 AM

Sorry Andy,

By clicking on the summary sheet, it will look up that cell value and find the correct sheet to open.

Thanks

**Andy Pope** · 05-22-2009, 11:12 AM

right click summary sheet tab and pick View code.
paste following.

Please Login or Register  to view this content.

**luffield** · 05-22-2009, 11:48 AM

Thanks Andy,

Thats Brilliant. can I ask one more with this spreadsheet?

The sheets such as pba are hidden so where will i need to insert code to show them again?

Luffield

**Andy Pope** · 05-22-2009, 11:54 AM

Please Login or Register  to view this content.

**luffield** · 05-22-2009, 12:07 PM

Andy,

That is simply brilliant. Thanks verymuch for your help

Click on 1 cell to goto another worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Click on 1 cell to goto another worksheet

Re: Click on 1 cell to goto another worksheet

Re: Click on 1 cell to goto another worksheet

Re: Click on 1 cell to goto another worksheet

Re: Click on 1 cell to goto another worksheet

Re: Click on 1 cell to goto another worksheet

Re: Click on 1 cell to goto another worksheet

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions