Windows – Add Any Extension to the New Context Menu

I want to add the option to make a new XLSM file (Macro-Enabled Excel file) directly from the New context menu (Right Click -> New on Desktop for example).

new-xlsm

 

Requirement: You need to be logged in on an Administrator account.

  1. Open Excel and save a new empty file as a “Microsoft Excel Macro-Enabled Workbook” in D:\ drive and name it “New File.xlsm” for example. Regardless of how you name it, its name won’t appear in the New context menu, neither will it be the name of the new file
  2. Right click on the Start Menu button and click Windows Powershell (Admin)
  3. Type the following command: Copy-Item "D:\New File.xlsm" -Destination "C:\Windows\ShellNew"
  4. You shouldn’t receive any error and if you check the C:\Windows\ShellNew folder your New File.xlsm should be there
  5. Open the Registry Editor
  6. Navigate to the following key: HKEY_CLASSES_ROOT\.xlsm
  7. Create a new Key under .xlsm Key and name it ShellNew. It’s path should be HKEY_CLASSES_ROOT\.xlsm\ShellNew
  8. Under ShellNew Key, create a new string value and name it FileName
  9. Double click FileName and enter the name of the file you saved at no. 1 with the extension, eg. New File.xlsm
  10. Now right click on Desktop, select New and see if you get the “Microsoft Excel Macro-Enabled Workbook” option.

regedit_shellnew

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More