LinkBack URL
About LinkBacks
Hi
I have 3 sheets eg. ( jan13 , mar13 , may13 ) . when I enter one of these names in a cell in another sheet & press a button ( drawn by inserting a shape ) it should open that particular sheet
Pls tell me how to do this
Rgds
Hi
I have 3 sheets eg. ( jan13 , mar13 , may13 ) . when I enter one of these names in a cell in another sheet & press a button ( drawn by inserting a shape ) it should open that particular sheet
Pls tell me how to do this
Rgds
do you really want to press a button?
I would do this completely differrently.
When you open the workbook, read all the sheetnames into an array.
then create a data Validation list in the cell that you are interested that lists the sheet names.
Finally run a macro whenever you change that cell to switch sheets.
So post your spreadsheet so I can show you how.
Back in ten mins.
Perhaps another option would be to create a list of all sheet names and hyperlink them, so when you click on the sheet name, you go there.
right-click on a cell and select "Name a range" call it Sheetnames.
then in "refers to, copy this...
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
Now, where you want the sheet names to appear, copy this down...
=IFERROR(HYPERLINK("#"&"'"&INDEX(Sheetnames,ROWS($A$2:A2))&"'!A1",INDEX(Sheetnames,ROWS($A$2:A2))),"")
This will create a list of hyperlinked sheet names. Copy it way past how-ever many sheet you have
If you really still want to have this in a shape, let me know
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have attached the file & instructions are on the first sheet. I prefer to select the sheet by assigning the macro to the button
thanks
Ok
'If you don't want to push a button
your code is:-
Please Login or Register to view this content.
Last edited by mehmetcik; 12-14-2013 at 03:32 PM.
If you insist on using a button then your code becomes:-
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks