Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments
Hi All,
I have a macro that hides some columns. But it doesn't work if comments in the columns that are to be hidden have their protection property set to "Don't move or size with cells" Is there a macro I can write that changes the properties of all the comments to "Move but don't size with cells" All help is greatly appreciated -- _______________________ Naz, London |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments
Hi Naz,
From the macro recorder, might be able to use the line ".Placement = xlMove". Range("G5").AddComment Range("G5").Comment.Visible = False Range("G5").Comment.Text Text:="L. Howard Kittle:" & Chr(10) & "" With Selection .Placement = xlMove .PrintObject = True End With HTH Regards, Howard "Naz" wrote in message ... Hi All, I have a macro that hides some columns. But it doesn't work if comments in the columns that are to be hidden have their protection property set to "Don't move or size with cells" Is there a macro I can write that changes the properties of all the comments to "Move but don't size with cells" All help is greatly appreciated -- _______________________ Naz, London |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments
Thanks Howard but i don't think this is what i need.
Let me clarify, the comments are put in by other people as normal into a cell. Then when i run the macro it fails. What i need is a macro that selects all the comments on the sheet and changes the property. What i need is something like select all comments with selection .Placement= xlmove end with but i don't know how to select all the comments on a sheet. -- _______________________ Naz, London "L. Howard Kittle" wrote: Hi Naz, From the macro recorder, might be able to use the line ".Placement = xlMove". Range("G5").AddComment Range("G5").Comment.Visible = False Range("G5").Comment.Text Text:="L. Howard Kittle:" & Chr(10) & "" With Selection .Placement = xlMove .PrintObject = True End With HTH Regards, Howard "Naz" wrote in message ... Hi All, I have a macro that hides some columns. But it doesn't work if comments in the columns that are to be hidden have their protection property set to "Don't move or size with cells" Is there a macro I can write that changes the properties of all the comments to "Move but don't size with cells" All help is greatly appreciated -- _______________________ Naz, London |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments
Naz
Public Sub Comment_Place() Dim cmt As Comment Dim cmts As Comments Set cmts = ActiveSheet.Comments For Each cmt In cmts cmt.Shape.Placement = xlMove Next End Sub Gord Dibben Excel MVP On Sun, 23 Oct 2005 11:20:02 -0700, Naz wrote: Thanks Howard but i don't think this is what i need. Let me clarify, the comments are put in by other people as normal into a cell. Then when i run the macro it fails. What i need is a macro that selects all the comments on the sheet and changes the property. What i need is something like select all comments with selection .Placement= xlmove end with but i don't know how to select all the comments on a sheet. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments
for each cmt in Activesheet.Comments
cmt.Placement= xlmove Next -- Regards, Tom Ogilvy "Naz" wrote in message ... Thanks Howard but i don't think this is what i need. Let me clarify, the comments are put in by other people as normal into a cell. Then when i run the macro it fails. What i need is a macro that selects all the comments on the sheet and changes the property. What i need is something like select all comments with selection .Placement= xlmove end with but i don't know how to select all the comments on a sheet. -- _______________________ Naz, London "L. Howard Kittle" wrote: Hi Naz, From the macro recorder, might be able to use the line ".Placement = xlMove". Range("G5").AddComment Range("G5").Comment.Visible = False Range("G5").Comment.Text Text:="L. Howard Kittle:" & Chr(10) & "" With Selection .Placement = xlMove .PrintObject = True End With HTH Regards, Howard "Naz" wrote in message ... Hi All, I have a macro that hides some columns. But it doesn't work if comments in the columns that are to be hidden have their protection property set to "Don't move or size with cells" Is there a macro I can write that changes the properties of all the comments to "Move but don't size with cells" All help is greatly appreciated -- _______________________ Naz, London |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
comments | Excel Discussion (Misc queries) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Comments | Excel Programming | |||
Comments | Excel Programming |