mscallisto
Technical User
I currently have a Personal.xls file in
C:\Program Files\MicroSoft Office\Office11\xlstart\
and have a macro to place a path and filename in my headings.
I would like to add another macro that would fill the cell I am currently in (any sheet) with the current date [when I hit CTRL & T].
I simply need some syntax assistance.
C:\Program Files\MicroSoft Office\Office11\xlstart\
and have a macro to place a path and filename in my headings.
Code:
Sub Set_Head_Foot()
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = "&""Comic Sans MS,Italic""&10" & ActiveWorkbook.Path + "\" + ActiveWorkbook.Name
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
End Sub
I would like to add another macro that would fill the cell I am currently in (any sheet) with the current date [when I hit CTRL & T].
I simply need some syntax assistance.