Hi Folks,
I have created a p'word protected xlt workbook. When I open the file from
windows explorer it will open as an xls 'version' as it should. However most
users will use the excel file-open options to get the file which means it
stays as a template.
Can anyone help me out with some some VBA which is beyond my current
knowledge?

As soon as the template is loaded as read only I would like the file to
automatically remove the password and prompt the user to re-save under a new
name using the xls extension (selected for them as the save-as window stays
on xlt).

Hope this makes sense. Can this be done?
Your help appreciated.