excel tabs

[Guest]

I need to put addresses on the tabs but there isn't enough room to type the
entire address. Can I make the tabs so they hold more characters?

 

[Don Guillett]

a bit more explanation?

 

[Guest]

I made a spreadsheet that needs street addresseson the tabs. I don't have
room to type the complete street names on the tabs.
Lin

 

[Don Guillett]

One solution would be to put your info on a master sheet. Rename your other
sheets
1,2,3,4,5,etc
and use this by right click master sheet tab>insert this>save.
Now when you double click on the row with the address you will goto the
sheet.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Sheets(Target.Row).Select
End Sub

 

[Gord Dibben]

Sheet Tab names are limited to 30 characters.

Find some other naming method.


Gord Dibben Excel MVP