How do I get Excel filename using a single keystroke
Ah, who reads the subject lines????
<vbg
Gord Dibben wrote:
You did say "keystroke".
Assign a shortcut key combo to the macro.
Gord
On Thu, 19 Oct 2006 11:00:39 -0700, Gord Dibben <gorddibbATshawDOTca wrote:
David
Assign this macro to a Toolbar button.
Sub NameinCell()
Range("A1").Value = ActiveWorkbook.FullName
End Sub
Gord Dibben MS Excel MVP
On Thu, 19 Oct 2006 09:35:01 -0700, David
wrote:
I'm trying to create a single icon which will give me the filename and path
of my spreadsheet. I know the longhand way - ie cell"filename") - I'm looking
for a quicker way.
Can anyone help?
Gord Dibben MS Excel MVP
--
Dave Peterson
|