Automate Excel tabname

		Microsoft Office Forums > Microsoft Excel > Excel
Automate Excel tabname

FAQ

Thread Tools

Display Modes

12-05-2008, 10:37 AM

Emily

Novice

Join Date: Dec 2008

Location: Hong Kong

Posts: 7

Code:

 
' Module    : Sheet3

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target = "" Then Exit Sub
    If Target.Address = "$C$53" Then ActiveSheet.Name = Target
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM
How do I use an Excel form to populate and Excel spreadsheet	apostht	Excel	0	05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:50 AM.