Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste-link tab name via vba editor
In Excel 2007 I wish to use the code below that I found and pasted on this
site but I have never used the vba editor. I can get to where the program goes, but I am not sure what part of the formula needs to be replaced with the actual workbook, worksheet, cell locations. For instance in my workbook named "Bk Stats Master_Forms", I have a worksheet named "Schedule". In the "Schedule" worksheet I have listed team names in column E. I want to link these team names to the worksheet tabs. For instance I want one worksheet tab name to be linked from "Schedule" worksheet cell "E6", then the next worksheet name to be linked from "Schedule" "E7" etc. All in the same workbook. What parts of the module are replaced with the actual workbook name, worksheet name, cell, location/destination? Thanks I Found this: "you have to use an event programme inthe vba open vb editor click control+R you get project window in the particular workbook right click <this workbook and click <view code copy this in the module" Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) ActiveSheet.Name = Range("a2").Value End Sub "whenever in the active sheet A2 is changed that sheet name is also changed." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
Formatting not retained using paste all and paste link | Excel Worksheet Functions | |||
"paste special" "paste link" | Excel Discussion (Misc queries) | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) |