Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - Auto - Sheet Name change ? expiry
1 . I want to change sheet name automatically by running macro (VB code)
if sheet name = x then sheet name will be changed to y after openning the file automatically. can u pls give me the code? -------------------------------------------------------- 2. if i want to trigger a macro on any change in sheet 1, what is the code? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - Auto - Sheet Name change ? expiry
1. Use the following (attach it to ThisWorkbook code)
Private Sub Workbook_Open() For Each ws In Worksheets If ws.Name = "Sheet1" Then ws.Name = "New Name" End If Next End Sub 2. Use Private Sub Worksheet_Change(ByVal Target As Range) 'Following will run only if there is a change in the range A1:A10 If Not Intersect(Target, Range("A1:A10")) Is Nothing Then 'Your code here... End If End Sub "Som" wrote: 1 . I want to change sheet name automatically by running macro (VB code) if sheet name = x then sheet name will be changed to y after openning the file automatically. can u pls give me the code? -------------------------------------------------------- 2. if i want to trigger a macro on any change in sheet 1, what is the code? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - Auto - Sheet Name change ? expiry
DearSom
Use the workbook open event and try this code. Private Sub Workbook_Open() Sheets("x").Name = "y" End Sub If this post helps click Yes -------------- Jacob Skaria "Som" wrote: 1 . I want to change sheet name automatically by running macro (VB code) if sheet name = x then sheet name will be changed to y after openning the file automatically. can u pls give me the code? -------------------------------------------------------- 2. if i want to trigger a macro on any change in sheet 1, what is the code? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - Auto - Sheet Name change ? expiry
To trigger a macro for change.
Use the below event. Launch VBE using Alt+F11. Insert Module. Double click sheet1 in treeview, drop down to see the below event. You can use the same event in 'Thisworkbook' to trigger this from anysheet in the workbook.. Private Sub Worksheet_Change(ByVal Target As Range) End Sub If this post helps click Yes -------------- Jacob Skaria "Som" wrote: 1 . I want to change sheet name automatically by running macro (VB code) if sheet name = x then sheet name will be changed to y after openning the file automatically. can u pls give me the code? -------------------------------------------------------- 2. if i want to trigger a macro on any change in sheet 1, what is the code? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto deletion of excel file after a certain date - expiry | Excel Discussion (Misc queries) | |||
Can I set up a sheet for reagents that will flag expiry dates? | Excel Discussion (Misc queries) | |||
Check dates in spreadsheet against expiry years column and change colour | Excel Worksheet Functions | |||
change sheet name macro | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |