Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
Default cell 'comment'.
When attempting to insert a comment the dialogue box initially contains my name. How do I stop this default entry? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
The comment is populated with the User Name from Tools, Options, General, User Name, but to remove the name you may need to enter a space in the Options window. gumdale_dogs Wrote: Default cell 'comment'. When attempting to insert a comment the dialogue box initially contains my name. How do I stop this default entry? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=487117 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
Also, check out:
http://groups.google.com/group/micro...116c7e6b72e050 HTH "Bryan Hessey" wrote in message news:Bryan.Hessey.1yw56m_1132650601.5376@excelforu m-nospam.com... The comment is populated with the User Name from Tools, Options, General, User Name, but to remove the name you may need to enter a space in the Options window. gumdale_dogs Wrote: Default cell 'comment'. When attempting to insert a comment the dialogue box initially contains my name. How do I stop this default entry? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=487117 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
hi, gumdale_dogs !
Default cell 'comment'. When attempting to insert a comment the dialogue box initially contains my name. How do I stop this default entry? you may use your 'own' custom AddComment macro ? i.e. Sub myAddComment() With ActiveCell If Not .Comment Is Nothing Then Exit Sub .AddComment "" .Comment.Visible = True ActiveSheet.Shapes(.Comment.Shape.Name).Select SendKeys " {BS}" Application.OnTime Now, "HideComment" End With End Sub Private Sub HideComment() ActiveCell.Comment.Visible = False End Sub hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Comments randomly move and resize regardless of settings | Excel Discussion (Misc queries) | |||
Comments problem | Excel Discussion (Misc queries) | |||
Lookup Text in Comments | Excel Worksheet Functions | |||
Include comments on another spreadsheet | Excel Discussion (Misc queries) | |||
Can I reference comments by Cell Name? | Excel Discussion (Misc queries) |