View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_14_] Bill[_14_] is offline
external usenet poster
 
Posts: 2
Default Changing Author Name in an existing cell's comment

Is there way to change/remove the Author name(Property) of
an existing comment within a cell. VBA Help says you can
set or return the Author Property. Return the existing
name is no problem, it's the setting I having issues with.
I like to change the Author's name so the Excel Status Bar
consistently shows the same name (or no name) for all
cells that contain comments (example: Cell A1 Commented
by 'my company name').

Thanks
Bill