sheet tab name
 

Is there a way to set the attached spreadsheet up so that the Vendor Name
(cell A4) appears in the sheet tab name?

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]

We do NOT attach workbooks to this ng. Re-post by asking a complete
question.

--
Don Guillett
SalesAid Software

"~Jeff~" wrote in message
...
Is there a way to set the attached spreadsheet up so that the Vendor Name
(cell A4) appears in the sheet tab name?

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]

Is there a way to set the attached spreadsheet up so that the Vendor Name
(cell A4) appears in the sheet tab name?


--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]
"Don Guillett" wrote in message
...
We do NOT attach workbooks to this ng. Re-post by asking a complete
question.

--
Don Guillett
SalesAid Software

"~Jeff~" wrote in message
...
Is there a way to set the attached spreadsheet up so that the Vendor
Name
(cell A4) appears in the sheet tab name?

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]

Use a worksheet_change event such as

if target.address="$A$4" then activesheet.name=target

--
Don Guillett
SalesAid Software

"~Jeff~" wrote in message
...
Is there a way to set the attached spreadsheet up so that the Vendor Name
(cell A4) appears in the sheet tab name?


--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]
"Don Guillett" wrote in message
...
We do NOT attach workbooks to this ng. Re-post by asking a complete
question.

--
Don Guillett
SalesAid Software

"~Jeff~" wrote in message
...
Is there a way to set the attached spreadsheet up so that the Vendor
Name
(cell A4) appears in the sheet tab name?

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

~Jeff~ wrote:
Is there a way to set the attached spreadsheet up so that the Vendor
Name (cell A4) appears in the sheet tab name?