• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto renaming of worksheet while creating new file

V

VDS

Member
@Dear All,

I have created a worksheet named "Audit Report.xls" with Right mouse click+ new worksheet. After opening the same, by default, it will create "Sheet 1" and renamed "2008-09".

However, what I want the name of worksheet to be changed to 2008-09 at the time of opening itself. Is it possible to create a macro/function to do this ?


VDS
 
Hi, VDS!

Do you happen to guess where should I have found this?
"Please Don't

PLEASE DON'T SHOUT! We have big ears and will hear you just the same."
(quoted).

If not perhaps you'd want to read the sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).

Regards!

PS: You've yet been warned on Wednesday, now again; next time your thread will be moderated and closed. If keeping on with the same attitude, then deleted. The community deserves the respect that it gives you.
 
Last edited:
VDS,
Exactly what do you require-- To rename a worksheet when u create a new workbook or when u create a new(insert ) worksheet. And every time do u want to rename it as "2008-09"
 
You must log in or register to reply here.
Back
Top