I need a specific workbook to open a specific template anytime someone opens a new worksheet in that that workbook, and I need that worksheet to be automatically named the current date. Can anyone help me with this? (If it would help, I can upload the workbook...)
I put the macro in the workbook module.
You need to go to visual basic, select view project explorer,
select this workbook.
Please Login or Register to view this content.
You could have saved it in a normal module but then you need to change the name.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
It's more like: when I open EVP-CL.xlsm I want it to open a new worksheet that uses the template CallLog.xltm and names the new sheet with the current date, in (mm-dd-yy) format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks