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
[email protected]
"sandlapper" <[email protected]> wrote in message
news:[email protected]...
> 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
> [email protected]
> "sandlapper" <[email protected]> wrote in message
> news:[email protected]...
> > 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 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

--
Don Guillett
SalesAid Software
[email protected]
"ljw9292" <[email protected]> wrote in message
news:[email protected]...
> 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
> > [email protected]
> > "sandlapper" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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"
<[email protected]> 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?