Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Note Code Help
I have the following code:
On Error Resume Next Dim curComment As String curComment = "" curComment = Target.Comment.Text If curComment < "" Then curComment = curComment & Chr(10) Target.AddComment Target.Comment.Text Text:=curComment & _ ActiveWorkbook.BuiltinDocumentProperties("Author") & _ ": Rev. " & Format(Date, "mm-dd-yyyy") & ", From (" & Worksheets("Password").Range("A16").Value & ")" I have two problems: 1) I want it to put in the note the person who is logged in, not the ("Author"). 2) I want this note to be visibale. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Like a note but it's not-What is it? | Excel Discussion (Misc queries) | |||
Validation note to comment note | Excel Discussion (Misc queries) | |||
a note on a workbook | Excel Worksheet Functions | |||
I want to insert a note | Excel Discussion (Misc queries) | |||
A Thank You note to Pio Sjoblom | Excel Programming |