excel tabs
 

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?

a bit more explanation?

--
Don Guillett
SalesAid Software

"sandlapper" wrote in message
...
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?

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" wrote:

a bit more explanation?

--
Don Guillett
SalesAid Software

"sandlapper" wrote in message
...
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?

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 tabinsert thissave.
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

--
Don Guillett
SalesAid Software

"ljw9292" wrote in message
...
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" wrote:

a bit more explanation?

--
Don Guillett
SalesAid Software

"sandlapper" wrote in message
...
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?

Sheet Tab names are limited to 30 characters.

Find some other naming method.


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 03:25:01 -0700, "sandlapper"
wrote:

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?