LinkBack URL
About LinkBacks
r70 
If i have a 10 sheets with different names and i have a list of these names how can i create a button to display the worksheet containing the name that i choose from the list
If i have a 10 sheets with different names and i have a list of these names how can i create a button to display the worksheet containing the name that i choose from the list
Last edited by r70; 09-06-2012 at 03:29 PM.
Rather than a button for each, may be you can hyperlink them.
See discussion here
Regards,
Vandan
Well Thank you vandan But Im trying to Make one button to all names ...if i choose a name from the list and then clicking the button it will go to the named sheet ...not for each name a button.
r70
ooops, sorry Arlette...I was typing my post while you posted yours.
Thanks Vandan Well done
Assuming you have a drop down in A1 with your list of Sheet names, then assign your button the following macro:
Sub ActivateSheet() Dim wSht As Worksheet Set wSht = Worksheets(Range("A1").Value) wSht.Select End Sub
Last edited by vandan_tanna; 09-06-2012 at 01:48 PM. Reason: code tags
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks