As suggested in the other post, you need to use the event listen with FileNewNotify2 event. As it was a small/quick macro, I've made it as it might be useful to lot of people.
Also for anyone looking to auto start this macro on start of SOLIDWORKS, refer to solution in this post Is there any way to force start a macro on startup of solidworks
Mike Flanders wrote:
I would like my part template to pop up the save window soon as I open the template. Is this something that could be done with a macro? I thought at one time it was a setting in Solidworks to automatically prompt me to save a part name on creation of it.
I'd like that macro too... especially for new assemblies
Is this the setting you're thinking of?