1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Excel Vba Show Hide Comments

[Solved] Excel Vba Show Hide Comments | Vb - Code Explorer | yomemimo.com
Question : excel vba show hide comments

Answered by : vastemonde

' Adds a comment, masks / shows all comments
Sub TestMe() With Worksheets(1).Range("e5").AddComment .Visible = False .Text "reviewed on " & Date ' End With ' Hides all comments Application.DisplayCommentIndicator = xlCommentIndicatorOnly ' Shows all comments Application.DisplayCommentIndicator = xlCommentAndIndicator
End Sub

Source : | Last Update : Sat, 30 Jan 21

Answers related to excel vba show hide comments

Code Explorer Popular Question For Vb