Create registry edit .reg file to delete specific keys

[Legoman]

Can someone help with the required text to delete these specific registry keys from Microsoft Office for me please?

Hidden Content

Give reaction to this post to see the hidden content.

I believe these two keys are causing Excel to always open windowed when I want it to open maximised instead and they keys keep getting recreated through every reboot/restart, so I need a quick and easy double-click way of killing them.

Thanks

[Bad Karma]

Before tweaking the registry, a couple of things to try. Open Excel, size the window to desired size using the side or corner drag handles (don't just click the maximize button). Once it is sized to your liking, close Excel. Now reopen. Did it retain this size?

Also, if you are opening Excel from a shortcut on your desktop, startmenu or taskbar, right click on the icon and choose properties. Click the Shortcut tab and look at the "Run" field. Does it say "Normal Window"? Normal window remembers the last non-full window setting and opens to that -- every time. If so, choose "Maximized", click "Apply" and OK to close. Now, Excel will always open full screen.

[Legoman]

20 hours ago, Bad Karma said:

Before tweaking the registry, a couple of things to try. Open Excel, size the window to desired size using the side or corner drag handles (don't just click the maximize button). Once it is sized to your liking, close Excel. Now reopen. Did it retain this size?

Also, if you are opening Excel from a shortcut on your desktop, startmenu or taskbar, right click on the icon and choose properties. Click the Shortcut tab and look at the "Run" field. Does it say "Normal Window"? Normal window remembers the last non-full window setting and opens to that -- every time. If so, choose "Maximized", click "Apply" and OK to close. Now, Excel will always open full screen.

To the first question: Yes. But this behaviour only sticks for the current boot. After reboot it goes back to being windowed again

To the second suggestion: No, this isn't relevent because I do not typically start the program from any kind of shortcut at all. Rather I just double click an Excel file which is associated with the program to be launched automatically.

[Jamizon]

Does this work?

Hidden Content

Give reaction to this post to see the hidden content.

[Bad Karma]

2 hours ago, Legoman said:

To the second suggestion: No, this isn't relevent because I do not typically start the program from any kind of shortcut at all. Rather I just double click an Excel file which is associated with the program to be launched automatically.

The window state (maximized/restored) is tied to each Excel window. If you want to maximize all Excel windows, you will need to write and execute a VBA routine.

Microsoft Visual Basic for Applications (VBA) is Microsoft’s Event Driven Programming Language. There are VBA codes that force Excel files to open in full-screen view or not in full-screen view. No matter your experience with VBA codes, you can simply follow this procedure to use this feature to force or stop Excel from opening in full screen.

Keep in mind that you need an additional Developer tab on your ribbon before following the steps.

Steps:

• First of all, go to the Developer tab on your ribbon.
• Then select Visual Basic from the Code group.

• As a result, the VBA window will open up separately. Now click on the Insert tab in this window.
• After that, select Module from the drop-down list.

• Next, put in the following code in the newly created module.

Sub Turn_On_FullScreen()
 Application.DisplayFullScreen = True
End Sub
Sub Turn_Off_FullScreen()
 Application.DisplayFullScreen = False
End Sub

 

• After that, close the window.
• Now go back to the Developer tab and select Macro from the Code group.

• At this instant, the Macro box will open up. Now select the Macro name you desire for your operation. We are selecting the Turn_Off_Fullscreen to stop Excel from opening in full screen. (you can select Turn_On-FullScreen to open Excel in full screen)

• Then click on Run.
• Finally, save the file and close it.

Excel will now stop or start opening in the full screen depending on the macro you have selected from the Macro box.

 

[Legoman]

1 hour ago, Jamizon said:

Does this work?

Hidden Content

Give reaction to this post to see the hidden content.

Yes it does. I'd already found and tried that. It works, but only for the current boot time. As soon as you reboot the computer, the problem is back.

[Legoman]

1 hour ago, Bad Karma said:

Excel will now stop or start opening in the full screen depending on the macro you have selected from the Macro box.

 

Thank you very much for the detailed suggestion, but isn't writing a whole Macro just to brute force a piece of craptastic programming by Microsoft a bit over the top? If brute force is really the only solution, then wouldn't

Hidden Content

Give reaction to this post to see the hidden content.

just be a whole lot easier?

[Legoman]

In an attempt to answer my own question, would this text work in .reg file to remove two problematic registry keys without destroying the entire nest? The problematic keys are named Pos and Maximized.

Hidden Content

Give reaction to this post to see the hidden content.