As this forum is open internationally, it is unfair to assume pronunciation or spelling of user names. OP's user name is perfectly valid in some regions of the world.
@KreshBell
Per forum rules, please remember to include your links to cross posts:
https://www.mrexcel.com/board/threads/create-new-workbook-from-exist.1265404/
https://www.excelforum.com/excel-pr...ate-new-xlsx-file-with-macro.html#post5986877
REMINDER: Like many forums, we have a rule that you include links to cross-post threads. We don't mind cross-posting, but please let us know about other threads so we know if other solutions have been tried/reached already.
You will need to create a unique macro for each button on the main sheet that unhides the destination sheet and then navigates to it. For the Workbook_Open event and all the 'Return to Menu' boxes, you can use a macro like
Private Sub Workbook_Open()
Dim ws As Worksheet
'Prevent...
Please remember that while cross-posting is allowed, you need to include the links to your other post(s).
https://www.mrexcel.com/board/threads/need-suggestions-on-what-to-use-for-a-real-time-tracker-which-auto-refreshes-the-data-every-hour.1256648/
Thanks for trying Hui. Is there a good/better way to contact Chandoo? It seems like we need more of a super-admin presence in the forums. I've not been successful in my attempts to reach out to him.
Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
If you do cross-post, please put that in your post.
Also if you have cross-posted and get an Solution elsewhere, have the...