If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Signature or Logo
Is there a way to put something in an excel spreadsheet as a signature or
logo or something to show that you made it? |
#2
|
|||
|
|||
Signature or Logo
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? |
#3
|
|||
|
|||
Signature or Logo
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 - |
#4
|
|||
|
|||
Signature or Logo
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 - |
Thread Tools | |
Display Modes | |
|
|