Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Comments | How to Format many at one time
Hello,
Can I set defaults to comments for them to act in a specific way? For example, I want the default of a comment for the properities to 'Move and Size with Cells' automatically. currently they are defaulted to 'Dont Move and size with cells." I have a workbook which has many comments and I am trying to hide rows and columns but because I have one comment not formatted correctly, the rows will not hide. I want to make sure that in the future I do not have to go through a spreadsheet and make sure that all the comments are formatted correctly. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Comments | How to Format many at one time
With some revision to code by Debra Dalgleish...............
Sub FormatAllComments() Dim ws As Worksheet Dim cmt As Comment For Each ws In ActiveWorkbook.Worksheets For Each cmt In ws.Comments With cmt.Shape .Placement = xlMoveAndSize End With Next cmt Next ws End Sub For more Comments coding see Debra's site at http://www.contextures.on.ca/xlcomments03.html Gord Dibben MS Excel MVP On Thu, 24 Jan 2008 12:21:30 -0800, cardosol wrote: Hello, Can I set defaults to comments for them to act in a specific way? For example, I want the default of a comment for the properities to 'Move and Size with Cells' automatically. currently they are defaulted to 'Dont Move and size with cells." I have a workbook which has many comments and I am trying to hide rows and columns but because I have one comment not formatted correctly, the rows will not hide. I want to make sure that in the future I do not have to go through a spreadsheet and make sure that all the comments are formatted correctly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a time format to a String format in Excel | Excel Discussion (Misc queries) | |||
Add time and date stamp to Excel comments. | Excel Discussion (Misc queries) | |||
Change format of all comments in an Excel worksheet | Excel Discussion (Misc queries) | |||
How can I pre format all Excel comments | New Users to Excel | |||
How can I pre format all Excel comments to Tahoma, font size 12, . | Excel Discussion (Misc queries) |