LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Som Som is offline
external usenet poster
 
Posts: 26
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto deletion of excel file after a certain date - expiry Som Excel Discussion (Misc queries) 7 March 20th 09 09:59 AM
Can I set up a sheet for reagents that will flag expiry dates? haem Excel Discussion (Misc queries) 1 March 6th 09 02:27 PM
Check dates in spreadsheet against expiry years column and change colour [email protected] Excel Worksheet Functions 4 January 22nd 07 05:14 AM
change sheet name macro WBTKbeezy Excel Worksheet Functions 4 February 22nd 06 03:51 PM
Why can't my macro use Auto Filter when I told the Sheet Protecti. KC Rippstein Excel Worksheet Functions 1 October 28th 04 06:13 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"