• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 890
  • Last Modified:

can't save excel 2010 xlsm workbook as xltm template

I have an Excel 2010 template (OSI.xltm) with macros that I used to create a new workbook (NewFile.xlsm). I then went to "save as" type xltm but the drop down types only has xlsm. What am I doing wrong?
0
BobArnett
Asked:
BobArnett
  • 3
1 Solution
 
BobArnettAuthor Commented:
Addition info:
The workbook is not protected. The worksheets are although I tried "save as" with the worksheets unprotected.
0
 
jsdrayCommented:
try saving it as an xlsm first then reopen and save as xltm
0
 
BobArnettAuthor Commented:
Figured it out. There was some code (I'm not sure where it came from) that prevented saving the file as anything other than xlsm.
0
 
BobArnettAuthor Commented:
Sorry to waste your time.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now