Showing posts with label msoffice. Show all posts
Showing posts with label msoffice. Show all posts

Friday, October 13, 2023

Office 2010 Activation

The last non-bloat version of Microsoft Office is 2010. 
Good luck finding one to download. And if you find one it will probably be a retail version.
Only Volume versions can be activated with KMS

KMS_VL_ALL-49 works on both Windows and Office but it will not convert a retail version of Office to volume.

FrostRose was a older activator seemed to convert the Office install from retail to volume. At least this is how it appears to me. 

So if you try to activate with KMS_VL_ALL-49 and it reports failure because Office is retail, run FrostRose first. FrostRose portable is fine and causes Defender less freaking out. You may not even want KMS_VL_ALL-49 for Office and just use FrostRose. But if FrostRose gets zapped, KMS will now replace easily.

Why bother? KMS_VL_ALL-49 is simpler and has only a single dll to exclude. Not sure it will last longer but FrostRose would lose activation from time to time.

As always it's a moving target.

Now I see KMS_VL_ALL-50 floating around but I haven't found it anywhere I trust.

I don't think you can even buy a key for Office 2010 anywhere.

Or try this

Thursday, June 3, 2021

Microsoft Office In Safe Mode

 I don't use Outlook anymore but a friend could not start Outlook without admin.
He then could not drag/drop into email.
I disabled addins but it didn't help.
The only way I could fix it was starting Outlook in safe mode.

3 Ways
1. Run Box > outlook.exe /safe
2. Press and hold the Ctrl key, then select the Outlook shortcut
3.Make Shortcut
“C:\Program Files (x86)\Microsoft Office\root\Office16\OUTLOOK.EXE” /safe

Location Program Files or PF (x86) depends on if 32 or 64 bit version

I could not get the shortcut I made to work and was short on time so gave up.

Sunday, December 28, 2014

Uninstalling Microsoft Office

Try this
http://www.thewindowsclub.com/fix-cannot-uninstall-office-2003-2007-or-2010-from-control-panel

Wednesday, July 3, 2013

Excel Macro Protect Unprotect All Worksheets

Protecting/unprotecting multiple worksheets within a workbook is tedious. Here is a macro for doing either for all the sheets at one time within a workbook.
If you have a workbook open that contains one macro, that macro will be available to other open workbooks or worksheets if macros are enabled in that workbook.
I have copied the information from here in case his site goes south.

If You've Never Run Macros Before
By default, Excel is set to prevent macros from running. You will have to use the following steps once to allow macros to run.

• In Excel 2010:
Choose File, Options, Trust Center, Trust Center Settings, Macro Settings, Disable All Macros with Notification

•In Excel 2007:
Choose Office Button, Excel Options, Trust Center, Trust Center Settings, Macro Settings, Disable All Macros with Notification

• In Excel 2003 and earlier:
Choose Tools, Macro, Security, Medium
Switch from Excel to the VBA Editor
Every Windows version of Excel since 1993 includes a powerful VBA development environment lurking behind the worksheets. You can use VBA code to add new functionality to Excel. To get to the VBA environment, follow these steps:
1. Type Alt+F11
2. From the VBA menu, select Insert, Module
3. Press Ctrl+R to display the Project Explorer
You should now see a blank white canvas where you can enter VBA code on the right and a list of worksheets and your new module on the left, as shown in Figure 1.
Fig. 1
17MrExcelFig01

Paste the Macro
Copy and Paste the following lines into the VBA editor:
Sub ProtectAllSheets()
    For Each ws In ActiveWorkbook.Worksheets
        ws.Protect Password:="secret123"
    Next ws
    MsgBox "All Worksheets Protected"
End Sub
Sub UnProtectAllSheets()
    For Each ws In ActiveWorkbook.Worksheets
        ws.Unprotect Password:="secret123"
    Next ws
    MsgBox "All Worksheets Unlocked"
End Sub
At the two spots indicated in Figure 2, type the real password that you would like to use. The password in both macros should match.
Type Alt+Q to close the VBA editor and return to Microsoft Excel.

Fix File Associations For Microsoft Office

If Microsoft Office does not associate properly with an xlsx file, here is a little program that will fix it. It will fix other associations also but I recently had a problem after installation of Office 2010 and later uninstalling Office 2003.

Program here: Nice little stand alone program. I suppose there is a way to fix the association without the program but it defied my attempts and I ran out of patients.

Go to "File Type Settings" and on the bottom left choose "Change 'Open with' programs. Then find xlsx extension and choose next. Now Excel 2010 should appear as a choice. Windows refused to show Excel 2010 as a choice without this little program and manually locating Excel and choosing it from within Windows would not stick so this little guy is doing something special.

Wednesday, September 23, 2009

Office 2007 File Types (Clever Capitalism)

Microsoft's insistance on playing Were's Waldo with its menu items really out did itself with Office 2007. Some of the standard stuff is under the fancy icon in the upper left.

Especially important is the options menu. (Word and Excel)
This is were you will determine the default file type for saving files. Change this to the types used by mortal humans. If you want anything and everything to read the file use RTF.


Edit:
Novice users do not know about file extensions because Windows defaults to hide file extensions. Do yourself a favor and uncheck "Hide extensions for known file types" in Control Panel > Folder Options > View. This will help you understand what is going on with file types.

5 ways to open docx files

Or:
Just use Google Documents but it will save in .doc/.xls format (a good thing in most cases).
Wordpad handles .docx also, just type wordpad in the start menu. Wordpad will not save the .docx as .doc but choosing .rtf is good.

Some educational institutions require docx which is a good way to sell software and partner with Microsoft's revenue stream. So much for fighting ugly capitalism in academia.

Edit: Office 2010 instructions for changing docx save to doc:

BitLocker

BitLocker: How to Protect Yourself Even If You Don’t Use It Many Windows users (including me) run local accounts and never intentionally ...