Showing posts with label Registry. Show all posts
Showing posts with label Registry. Show all posts

Wednesday, November 2, 2011

Open 2 Excel Files in separate windows

WARNING: Changing your registry can be dangerous to the health of your computer. Do so at your own risk.

This change makes it so when you click an Excel file it will ALWAYS open in a new window (a different instance of Excel)

 

.XLSX

  1. I highly recommend you back up your registry before making any changes.
  2. Open regedit.exe
  3. Navigate to HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command
  4. Open (Double-click) the key called (Default)
  5. Change the value from
          "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" /e
    to "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" /e “%1”
  6. Click the OK button
  7. Below the (Default) key you will see a key with the name command.
    Right click it and select Rename.
    Change the name to something else (it doesn’t matter what)
  8. Your screen should now look something like the following (I appended bv to the command key, but you should probably use something different)

    image
  9. Navigate to HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/ddeexec
    Right click it and select Rename.
    Change the name to something else (it doesn’t matter what)
  10. Your screen should now look something like the following:

    image
  11. You have now successfully made it so that when you open an existing Excel file (that has the extension .xlsx) it will open in a new window. This allows you to easily compare or view two Excel file at the same time. This is particular helpful if you have two monitors. You can also ways revert back if you decide you don’t like the change by undoing the changes made here, that is why we renamed instead of deleted the keys.

.XLS

You can follow the same instructions for .XLS except you will want to amend the instruction so that where ever you see Excel.Sheet.12, replace it with Excel.Sheet.8.

BTW, I found this tip here.

Tuesday, February 1, 2011

Solution for Can’t disable/enable add-on in Internet Explorer

If you can’t enable or disable any add-ons in Internet Explorer then it is likely that there is a group policy that is preventing you from doing it. Like most group policies they can be temporarily overwritten by modifying the registry key. You can copy and paste the text in blue into a text file and give it the .reg exension. Now when you open it, it will modify the registry for you. Below the setting is set to 0 which means that you CAN enable or disable add-ons in Internet Explorer. Set it to 1 to prevent yourself from doing it. NOTE: HKLM is for all users, however if you go to the same path, but for HKCU the change will only affect you unless there is a value in HKLM which will then override the user value (I think).

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Internet Explorer\Restrictions]
"NoExtensionManagement"=dword:00000000

Friday, October 30, 2009

Disable AutoRecover in Microsoft SQL Server Management Studio

According to numerous posts and my own poking around, Microsoft did not make the Auto Recovery feature configurable. This means you can’t turn it off in the UI or change the frequency of the saves. This is a bit of a pain when I work from home because I have a roaming profile and the location the Auto Recovery feature writes to is on the network and makes SSMS hang.

Thankfully, there are two registry keys that you change.

Put the contents below in a file with a .reg extension, double-click it and this will turn off the auto recovery feature.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover]
"AutoRecover Always Enabled"=dword:00000000
"AutoRecover Enabled"=dword:00000000

To turn it back on, just change the AutoRecovery Enabled = 00000001.

Tuesday, October 20, 2009

Enable Windows Update

Many times group policy disables Windows Update so that Corporate IT has the ability to control what gets pushed to a corporate computer. Sometimes it is useful to get around this.

As with many hacks to group policies you just need to edit your registry.

Delete the following keys in the registry using regedit

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer\NoWindowsUpdate

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Windows Update\DisableWindowsUpdateAccess

Do this at your own risk of course. This KB from Microsoft explains different reason why you may be getting the message in the first place. http://support.microsoft.com/default.aspx?kbid=326686

Monday, October 19, 2009

Allowing Windows Scheduled Tasks to be editable

If you have a company computer the Group Policy may not allow you to edit or add new Scheduled Tasks. Luckily, you can override those settings until the Group Policy is refreshed. Below is what needs to be changed in the Windows Registry to allow you to edit or add the Scheduled Tasks (under Start Menu | Control Panels).

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Task Scheduler5.0] "Disable Advanced"=dword:00000000 "Property Pages"=dword:00000000 "Execution"=dword:00000000 "Allow Browse"=dword:00000000 "DragAndDrop"=dword:00000000 "Task Creation"=dword:00000000 "Task Deletion"=dword:00000000

[HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows\Task Scheduler5.0] "Allow Browse"=dword:00000000

To create a double-clickable file just open up your favorite text editor such as NotePad++ or NotePad. Paste the contents above into your text editor, and save it in a file of any name, as long as the extension is .reg.

Double-click the file to merge the settings into the registry. You should now be able to add or edit your scheduled tasks.