paste-link tab name via vba editor


I

i2meek

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."
 
Ad

Advertisements

D

Don Guillett

Pls do NOT post in multiple groups with multiple subject lines. All you do
is waste time and effort. See other post
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top