| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change property of comments only
Hi there,
I'd like to change property of comments only with a macro. The code in http://support.microsoft.com/default...b;en-us;211769 is changing the property of all objects in the sheet. Does anyone know if this is possible. -- Regards, Martin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change property of comments only
What property do you want to change and do you want to change all comments
or just one comment? -- Regards, Tom Ogilvy "Martin" wrote in message ... Hi there, I'd like to change property of comments only with a macro. The code in http://support.microsoft.com/default...b;en-us;211769 is changing the property of all objects in the sheet. Does anyone know if this is possible. -- Regards, Martin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change property of comments only
Hi Tom,
Sorry I was not clear enough. I want to change all comments to xlMove. -- Regards, Martin "Tom Ogilvy" wrote: What property do you want to change and do you want to change all comments or just one comment? -- Regards, Tom Ogilvy "Martin" wrote in message ... Hi there, I'd like to change property of comments only with a macro. The code in http://support.microsoft.com/default...b;en-us;211769 is changing the property of all objects in the sheet. Does anyone know if this is possible. -- Regards, Martin |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change property of comments only
Sub abcd()
For Each cmt In ActiveSheet.Comments cmt.Shape.Placement = xlMove Next End Sub -- Regards, Tom Ogilvy "Martin" wrote in message ... Hi Tom, Sorry I was not clear enough. I want to change all comments to xlMove. -- Regards, Martin "Tom Ogilvy" wrote: What property do you want to change and do you want to change all comments or just one comment? -- Regards, Tom Ogilvy "Martin" wrote in message ... Hi there, I'd like to change property of comments only with a macro. The code in http://support.microsoft.com/default...b;en-us;211769 is changing the property of all objects in the sheet. Does anyone know if this is possible. -- Regards, Martin |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change property of comments only
Brilliant, thanks a lot.
-- Regards, Martin "Tom Ogilvy" wrote: Sub abcd() For Each cmt In ActiveSheet.Comments cmt.Shape.Placement = xlMove Next End Sub -- Regards, Tom Ogilvy "Martin" wrote in message ... Hi Tom, Sorry I was not clear enough. I want to change all comments to xlMove. -- Regards, Martin "Tom Ogilvy" wrote: What property do you want to change and do you want to change all comments or just one comment? -- Regards, Tom Ogilvy "Martin" wrote in message ... Hi there, I'd like to change property of comments only with a macro. The code in http://support.microsoft.com/default...b;en-us;211769 is changing the property of all objects in the sheet. Does anyone know if this is possible. -- Regards, Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change insidewidth property | Charts and Charting in Excel | |||
| how to use object variable to change the property of a | Excel Programming | |||
| Combobox change property | Excel Programming | |||
| change Company property | Excel Programming | |||
| Worksheet / Workbook Change Property | Excel Programming | |||
![Martin[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
