|
|
|
|
"Dave Peterson" wrote:
VBA is built into excel (as well a bunch of other programs). But I believe you
do have to choose to install it.
If you click on Tools|macro|Visual basic editor, do you have any problems?
(VB--plain old Visual Basic is a stand alone program. But you don't need it to
write macros in excel/word/powerpoint....).
mykmag wrote:
Thank you very much. Of your name I guess you are of Swedish origin. I
myself, is Norwegian.
I would like to know if VisualBasic,VBA is build in Excel 2003 or must I
have the whole program to make a macro? I think I have a CD with some old
program on, and I have some programming experience mainly with dBASE and a
litle Pascal and I have tried some VBA as well (very little).
Yours
Magnar Myklebust (retired)
Ellingsrudlia 24
1400 Ski
Norway
E-mail
"Dave Peterson" wrote:
If you use VBA, you can.
Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Worksheets("sheet1")
.PageSetup.RightHeader = "This is what's in A1: " & .Range("A1").Text
.PageSetup.LeftHeader = Format(Date, "mmmm dd, yyyy")
End With
End Sub
This kind of code goes behind the ThisWorkbook module.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
mykmag wrote:
Is it possibe to insert a cell referance/link of your own make, in the
heading/footer of a page/sheet in Excel 2003?
--
Dave Peterson
--
Dave Peterson
|