Different strokes..................and all that.

The workbook_open ensures the cell is filled in.

A button requires a user operation.

Just my take.


Gord


On Tue, 23 Sep 2008 12:19:19 -0700 (PDT), JP wrote:

Personally I prefer a command button (Control Toolbox) that fills in
the cell.

Just thought I'd share that.

--JP

On Sep 23, 2:49*pm, Gord Dibben gorddibbATshawDOTca wrote:
Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Value _
= ActiveWorkbook.BuiltinDocumentProperties("Author")
End Sub

Gord Dibben *MS Excel MVP

On Tue, 23 Sep 2008 10:10:01 -0700, Vercingetorix.XIII



wrote:
Is there a way to put something in an excel spreadsheet as a signature or
logo or something to show that you made it?- Hide quoted text -

- Show quoted text -