New Sheet with automatic naming & easy file navigation

[TimvMechelen]

Hi all,

I would like to have an excel file where I can easily navigate through the sheets.
I have sheets for each week, but when I need an extra week, I would like to add a next sheet with one click. A macro is required for that.
When that macro adds a new sheet, I would like the macro to rename that sheet a specific way: with year and weeknumber.

Other specific information is described in the example below.
https://www.dropbox.com/s/hseeolq720z88u3/Example Sheet navigation.xlsm?dl=0


Thanks for your help.

 

[TimvMechelen]

Did you try putting this Userform in your personal workbook where it can be used on any workbook like I explained in post 35?

Thanks for helping!
Yes, but I can't find that folder Personal workbook

 

[My Aswer Is This]

Try this:

In the Vba Project window where you see your UserForm.

Do you also see something like this:
VbaProject(Personal.xlsb)

Just answer Yes or No

Do not do anything else yet.

 

[TimvMechelen]

No

 

[My Aswer Is This]

Take a look at this YouTube Video if your able to and then get back with me.
https://www.youtube.com/watch?v=rD2-mSbTuL0

This shows you how to create a Personal Workbook.

Do not move your Userform into this workbook till I tell you more.

 

[My Aswer Is This]

If your not able to see the video do this:

Start the Macro Recorder

When the widow popsup select save in Personal Workbook.

Then just select a cell and enter "Cake" for example
Then stop the recorder

Now you should see a Personal Folder in your Vba Project Window.

Then get back with me and I will explain more

 

[My Aswer Is This]

Never heard back from you if you achieved this task.

 

[TimvMechelen]

Never heard back from you if you achieved this task.

Hey I'm sorry, I'm quite busy at the moment. I'll get back to you when I have more time. I appreciate your help a lot!