Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Private Sub Workbook
Hi,
I was wondering how I can place the following macro into the workbook rather than having to inpu this code into over 100 individual sheets, the code changes the sheet tab name to that of cell A1 per every sheet, these are changed from the first sheet called Index of Stock, so when the name is changed in the index of stock it changes instantly on the individual sheet and the sheet tab. Here's the code. Private Sub Worksheet_Calculate() With Me.Range("A1") If .Value < "" Then Me.Name = .Value End If End With End Sub Many thanks Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Improve method of calling a private function in a private module | Excel Programming | |||
Private Sub Workbook_Open() event won't fire if workbook is hidden? | Excel Programming | |||
Private Sub Workbook Open() - question | Excel Programming | |||
re : Possible to run private sub macros by writing another private | Excel Programming | |||
Add code to Private Sub ComboBox1_Change() with a macro from a different workbook | Excel Programming |