Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    sydney, nsw, australia
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    saving to xlsm from xltm template

    I have created an xltm template containing macros (similar to an old xlt template). However, Excel saves new documents created from the template as xlsx files by default, which loses the macros.

    How can I change the situation so that files created from this xltm template are saved as xlsm files?

    Using Excel 2010 on Windows XP and Windows 7 PCs.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Save File Options

    Hi

    To choose the default file format go to

    FILE>>Options>>Save


    Cheers
    Geof
    Attached Images Attached Images

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •