+ Reply to Thread
Results 1 to 20 of 20

How to create only XLSM files when right click-New-Msn ExcelWorkbook

  1. #1
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Hi guys,

    Is there a trick on how I can create directly xlsm files when right click on desktop ==>New==>Microsoft Excel Workbook? By default is created a xlsx and then I have to save as in order to create an xlsm file.

    is there a way how I can create bu default only XLSM files?

    Thank you in advance,
    Ionut
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    When you create a new workbook, it's not any file-type format yet. The file-type is defined when you save it. You can change the default Save file type from .xlsx to .xlsm

    Change the default file format for saving workbooks
    Last edited by AlphaFrog; 09-25-2016 at 11:41 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Untested....but...There's an option in Excel to set the default file type.
    Try this:
    File.Options.Save....
    Save files in this format: (select .xlsm)

    Then try right-clicking the desktop to create an new workbook.

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  4. #4
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    If your file extension is not hidden then you can do this easily. Right click on desktop --> New text document --> Change the file name with extension (ex. YourFileName.xlsm).

    Or you can use CMD to change the extension. Press Ctrl+R --> Type CMD --> Enter --> Type Move --> Press Space --> Now drag and drop the new text document on Command prompt window --> Press Space --> Again drag and drop the new Text document on command prompt window --> change txt to xlsm on the last part --> Press Enter. You are done.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    @Ron and Alpha. Your solutions work for opening and saving within Excel. If however, as the OP has indicated, if you go to your windows desktop and right click on the desktop, you can immediately create a file with a default name that is saved but not opened on the desktop with an .xlsx file type. I think that this is the issue the OP wants to resolve. I have been looking at how to modify this by making a change in the Registry, but have not found a clear solution. I suspect there is a key in the registry (not yet found) that can be changed.

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Thanks for the heads up Alan. You're probably right.

  7. #7
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486
    Quote Originally Posted by alansidman View Post
    @Ron and Alpha. Your solutions work for opening and saving within Excel. If however, as the OP has indicated, if you go to your windows desktop and right click on the desktop, you can immediately create a file with a default name that is saved but not opened on the desktop with an .xlsx file type. I think that this is the issue the OP wants to resolve. I have been looking at how to modify this by making a change in the Registry, but have not found a clear solution. I suspect there is a key in the registry (not yet found) that can be changed.

    Alan
    Yeah Alan this is what I need. If i edit the type from xlsx to xlsm still will nott work. That's why i raised this topic here.
    Thank you!

  8. #8
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Hence the "untested" in my post

    I also just tried setting up a BOOK.xltm template in my XLSTART folder as the only workbook template in that folder....
    That didn't work either :|

  9. #9
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    lol...thanks for answering thou!

  10. #10
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    There are several utilities that allow to to Edit\Add to the Windows Desktop Context Menu. I think you can add a default file type with some of them though I haven't actually tried it.

    Here's two:
    Right Click Enhancer
    Ultimate Windows Context Menu Customizer

    You can find others by searching for something like Windows Context Menu Editor.


    From the discription for Right-Click Enhancer:
    Edit right click new menu with ease

    In Windows, whenever you right-click on Desktop or in Windows Explorer, you get "New" menu which allows you to create new folder, new shortcut and new files using various known file types. It helps you in creating new files, folders and shortcuts easily and quickly.

    Sometimes you may want to remove a few unneeded items from "New" menu to reduce its size or you may want to add a few new items to "New" menu such as new file types. New Menu Editor is a tool designed to do this job. You can even add file types with default content so you can create new files with easily with default content.

    For example, you have specific bill receipt template for your store in excel file. You can add this template to new menu using this tool. Now after you done that whenever you create new excel file using new menu that new file always contains the default receipt format.
    Last edited by AlphaFrog; 09-25-2016 at 03:35 PM. Reason: typo

  11. #11
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Cool! Thank you AlphaFrog!

    But directly through windows settings can't be done?

    Cheers,
    Ionut

  12. #12
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Hi,

    Yes it can be done.
    1. Create a new workbook and save it as Excel12.xlsm in the folder C:\Windows\ShellNew
    2. Open the registry editor and locate the .xlsm hive in HKEY_CLASSES_ROOT. Within it you should find a hive for Excel.SheetMacroEnabled12 and within that a ShellNew hive. Add a new string value to that ShellNew hive called FileName and give it the value Excel12.xlsm

    You should now see a new addition to the New context menu.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  13. #13
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Thank you xlnitwit! How I can open the registry editor? I need help on step 2.

    Thank you in advance!

  14. #14
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Hi again,

    If you press Windows key + r, it will open the run box. Enter regedit into the box and press enter.

  15. #15
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Xlnitwit you rock!

    It appeared. This is all I need.

  16. #16
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Xlnitwit how your steps can be replicated now to Office 2016? Thank you man!!!

  17. #17
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Do the same steps not work? I am not aware of anything version specific in the steps I detailed before.

  18. #18
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    no they dont. there are different names and different selections

  19. #19
    Registered User
    Join Date
    07-18-2014
    Location
    San Diego, California
    MS-Off Ver
    2007
    Posts
    1

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    I'm trying the solution to right-click desktop to select a .XLSM file.
    But the instructions don't appear to be accurate for Windows 11.
    I found Registry location: Computer\Hkey_Classes_Root\.xlsm folder.
    In the right pane of .xlsm folder I see: (Default) REG_SZ Excel.SheetMacroEnabled.12.
    But there's no ShellNew within Excel.SheetMacroEnabled12.
    There is a ShellNew two folders down from the ".xlsm" folder.
    Can you provide instructions from this point?
    Attached Images Attached Images

  20. #20
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to create only XLSM files when right click-New-Msn ExcelWorkbook

    Quote Originally Posted by GreanBean View Post
    I'm trying the solution to right-click desktop to select a .XLSM file.......
    Can you provide instructions from this point?
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #1 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert csv files in folder to xlsm
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-13-2015, 09:49 PM
  2. [SOLVED] slow vba running with xlsm files
    By Dturazza in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-24-2014, 09:36 PM
  3. Replies: 2
    Last Post: 10-04-2013, 10:12 AM
  4. [SOLVED] Open > Click Ok on Error > Save as .xlsm
    By Sweepin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2013, 06:49 PM
  5. Replies: 2
    Last Post: 08-13-2012, 05:20 PM
  6. Identify .xls and .xlsm files only
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2012, 06:37 AM
  7. xls to xlsm files
    By Pinokkio in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2010, 01:40 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1