Hi,
At work I use a spreadsheet template (*.xltm). I have always used this, but now when I try to save instead of defaulting to a Macro-Enabled Worksheet it goes to overwrite the template I am using. This was not happening before and I haven't changed any formatting.
When I check my excel options the default save file is macro-enabled workbook - as it has always been.
Also, now when I open the template it opens a new window for excel, preventing me from copying over worksheets, I hope this makes sense.
My colleagues all use the template and I have checked the properties of their shortcuts and mine is the same - yet it doesn't open up as a template on their computers.
Just wondering if there is a quick fix as it's is becoming increasingly annoying! Hope this makes sense...
Bookmarks