Tuesday, May 22, 2012

MS Office related

Printing with "Your margins are pretty small..." warning disabled
Macro – Print Without Margins Warning

Sub Print_ShowNoMarginsWarning_ShowPrintDialog()
    Dim bPrintBackgroud As Boolean

    'Save current setting of background printing
    bPrintBackgroud = Options.PrintBackground
    Options.PrintBackground = False

    'Turn off DisplayAlerts
    Application.DisplayAlerts = wdAlertsNone

    Dialogs(wdDialogFilePrint).Show

    'Turn on DisplayAlerts again
    Application.DisplayAlerts = wdAlertsAll

    'Set original background printing setting
    Options.PrintBackground = bPrintBackgroud
End Sub
---


Excel 2013 on Windows 8 not responsive (slow)
Office 2013 – Unresponsive, Slow, Typing Slow
Click File \ Options \ Advanced \ Scroll down to the “Display” section \ Uncheck (or Check, depending on current status) “Disable hardware graphics acceleration” and restart office.

Error "MSPCORE.DLL is missing" when opening Office Document Imaging:
Run Setup and make sure Document Imaging is installed (Run from this computer)

(Excel) Find external links/references:
How to find and list all links (external references) in Excel?
XL: Delete Links Wizard Available

No comments:

Post a Comment