textbox that forces user to name workbook

I've been struggling with this for a few days. I want the workboook to open with an inputbox that forces the users to name the workbook automatically. Been running into errors left and right however!.

when they open the workbook, which is a template. I want them forced to name the workbook, so yes like a "saved as" type solution

NEW TSR TEMPLATE.xlsmnew tsr summary.xls

This is my project. It is a TSR (training resource request) which allows people to request supplies for training like fresh food, ammo, transport etc. I want it to populate the TRACKER as automatically as possible.


I would like people using a request to be forced to name it differently then other people and have the status of each item on the TSR should its status on the tracker.

This seems pretty clear to me but I have seen alot of these so I'm probably taking alot of things for granted. If you need any more explanation let me know. I'm kinda stuck here

It was already a macro enabled worksheet at least it is on my computer.

That code did'nt seem to do anything for me

okay so that works fine. Now how would you recomend I go about populating the tracker with the information from that?

keep in mind the listings on the tracker (dukes, bravo, charles,echo and fox) are going to have multiple entries in them.


the way it works is that lets say Bravo company submitted a TSR named Ghost walker.

the name "ghost walker" would go into the reference number section and then the sections of the TSR (ammo, tgt req, FSR etc) get tracked according to when they are individually approved. I made them color coded but I'm not sure how I would be able to automatically populate this thing its driving me nuts.