Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel comments replace author
Is there a way to change Globally author in comments in Excel. ta
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel comments replace author
You'd have to use a macro.
Saved from a previous post: Option Explicit Sub testme01() Dim FoundCell As Range Dim FindWhat As String Dim WithWhat As String FindWhat = "ASDF" WithWhat = "qwer" Do Set FoundCell = ActiveSheet.Cells.Find(What:=FindWhat, _ After:=ActiveCell, _ LookIn:=xlComments, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=True) If FoundCell Is Nothing Then Exit Do Else FoundCell.Comment.Text _ application.substitute(FoundCell.Comment.Text, _ FindWhat, WithWhat) End If Loop End Sub application.substitute is case sensitive--so you'll have to match case. ====== If you're using xl2k or higher, you can use replace instead of application.substitute and that can be made non-case sensitive. Not_an_expert wrote: Is there a way to change Globally author in comments in Excel. ta -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel comments replace author
and to change for the future with the name you want
tools, options, General, User Name: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel: Add replace within selection functionality | Excel Discussion (Misc queries) | |||
Change format of all comments in an Excel worksheet | Excel Discussion (Misc queries) | |||
excel encounters an error when editing comments | Excel Discussion (Misc queries) | |||
Excel 2002 "Protect Sheet", but Allow "Insert Comments"? | Excel Worksheet Functions |