Automate Excel tabname

		Microsoft Office Forums > Microsoft Excel > Excel
Automate Excel tabname

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:02 AM.