Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
barbyy pe Simpatie.ro
 | Femeie
23 ani
Bucuresti
cauta Barbat
23 - 80 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2186
|
|
I want to add the option to make a new XLSM file directly from the New context menu (right click - new on Desktop for example).
To do this you need access to editing the Registry.
1. Open Excel and save a new empty file as Excel16.xlsm for example. I think you can use any name. Save it in C:\Windows\ShellNew
Can't save the file in the folder mentioned above? Receiving access denied or nothing happens? See 2nd post in this topic for an alternative! After that, you can continue with steps 2-7 in this post.
2. Open the Registry Editor (start - run - regedit)
3. Navigate to the following key: HKEY_CLASSES_ROOT\.xlsm
4. Create a new Key under .xlsm Key and name it ShellNew
It's path should be HKEY_CLASSES_ROOT\.xlsm\ShellNew
5. Under ShellNew Key, create a new string value and name it FileName
6. Double click FileName and enter the name of the file you saved at no. 1 with the extension, eg. Excel16.xlsm
7. Now right click on Desktop, select New and see if you get the "Microsoft Excel Macro-Enabled Workbook" option.
_______________________________________
|
|
| pus acum 2 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
For some folders in the Windows installation drive (usually C:\ drive) you don't have much access like creating new files or deleting files inside those folders. For security reasons it should stay this way.
Of course you can take ownership of folders and be allowed to do whatever you want inside, but it's recommended you don't as long as there are momentary options that help you doing something you need only once.
The folder C:\Windows\ShellNew is one of these protected folders where you can't create new files or remove files.
To bypass this only once and put the .XLSM file inside that folder you need to do the following steps, assuming you are logged in on an Administrator account:
1. Open Excel and save a new empty Macro Enabled Excel file in D:\ drive, right in the root of the drive. Name it "New File.xlsm" for example.
2. Right click on the Start Menu button and select 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. Now you can rename the file inside the ShellNew folder if you want.
5. Continue with steps 2-7 in the post above.
_______________________________________
|
|
| pus acum 2 ani |
|