Recent content by Luke M

When inputting the value, type the actual number like 418000000. After that, you can chance the format of the cell to display the value how you would like. In your case, that would be a format code of $0,,"M"

Your workbook has four code modules, and 3 macros. Can you narrow it down as to what macro/line of code you want help with?

You will have better luck starting a new, clean thread rather than appending, aka hijacking, someone else's thread.

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.

You'll have better luck getting an answer starting your own thread vs replying to others/old threads

@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

Conversation continued in separate thread: https://chandoo.org/forum/threads/continuation-allow-only-one-checkbox-true.57805/#post-309631

Hi Promyese43. I'd recommend starting your own thread with the question, rather than jumping on a thread that is more than a year old.

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.

Nothing new to report. I share your frustration in a lack of timely response.

Hello, While the lounge is meant to be less formal questions, we do ask that the questions relate somewhat to the topic of Excel.

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...

Nothing on my end. :(

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.