comment info

  • Thread starter Thread starter djsashaz
  • Start date Start date
D

djsashaz

Here is a good one.......

Is there a way to make a comment in the file properties from a cell in
excel?

I tried:
Recording a macro = no luck, wont recognize the file--> Properties -->
Comment edit

Lookin in VB = nothing to show that it can be done easily, maybe need
to go back to school? lol

The reason I ask this is, so that when I browes my excell folder, I can
add a comment tab in there and see what the files are. E.g. the files
are invoice numbers, and I don't want to change the file number to add
the company that I invoviced, but I need to recall the files quicker
for human interface so I can find them eaiser.
 
Is there a way to make a comment in the file properties from a cell in
excel?
Click to expand...
...

Play with this.

Sub foo()
ThisWorkbook.BuiltinDocumentProperties("Comments").Value = ActiveCell.Text
End Sub
 
Back
Top