Posts Tagged ‘ Macro ’

Macros to “Paste as Text” for Word and Excel

2017/11/07
By
Modified: 2017/11/05
Macros to “Paste as Text” for Word and Excel

These two macros will save you a lot of time.  They used, when you need to copy something from Internet page into a Word or Excel document, but  you do not need all the colors and formatting.   You just need the text. Usually you would do this with Paste Special, but this is several awkward clicks and many seconds lost.  Over the course of the day this is a huge inefficiency. Let’s write a macro for Word first. As of 2012-01-11 WED, I adopted this little macro as final version: Sub PasteText() On Error GoTo Unicode Selection.PasteSpecial Link:=False, DataType:=wdPasteText, _ Placement:=wdInLine, DisplayAsIcon:=False GoTo Done Unicode: Selection.PasteAndFormat (wdFormatPlainText) Done: End Sub This macro…

Read more »


Share Digital Certificate for VBA Between Several PC(s)

2017/10/18
By
Modified: 2017/09/16
Excel-Install-Certificate

This article is about time saving, when it comes to enable your macros in Excel every time you open the file. You do not want to allow all macro to run.  But if you don’t, you have to constantly enable your macros over and over again, when you open your Excel files.  To eliminate this, you can create a self-signed digital certificate and this work fine on one PC. But what, if you need to open the same files with macros from several PC(s) on your network.  I think I found a solution on how to create a certificate on one PC and then install that certificate on other PC(s). This…

Read more »

Excel Macro to Toggle Wrap Text

2012/01/14
By
Modified: 2012/01/02

This Excel macro allows changing cells in selection based on the first cell in a selection: If Selection.Cells(1, 1).WrapText = True Then Selection.WrapText = False Else Selection.WrapText = True End If   This is useful in Excel 2003 and bellow.  Starting from Excel 2007, there is a button to perform this task on a Task Ribbon.

Read more »