The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.The idea is to use the first line near the beginning of your macro, and then use the second line near the end.Here, I will talk about some quick tricks to show or hide all of the objects in Excel.
Complex Formulas: In Picture 1, the formula is simple - ‘=P7’.
NOTE: This creates new comments, without the original formatting.
If you need to copy comment pictures, or other formatting, use the macro in the next section - Replace Names With Pictures Sub Change Comment Name() 'replaces old names in comments 'deletes and reinserts comments ' so new name appears in status bar ' ws As Worksheet Dim cmt As Comment Dim str Old As String Dim str New As String Dim str Comment As String str New = "New Name" str Old = "Old Name" Application. Add Comment text:=str Comment Next cmt Next ws End Sub This macro is similar to the one above -- it replaces the old names attached to cell comments.
Picture 1, below, shows three items circled in red - cell P7, a shape, and the formula bar.
Normally, when a shape is selected, the Excel formula bar is empty. Cell Formatting: When a shape is first linked to a cell via formula, the shape font formatting is suddenly changed to match the formatting of the cell.