Imbedded Footers


Posted by Phyllis Keefer on October 19, 1999 7:00 PM

I am very new at Excel. I fear that I will never catch on to this. My husband on the other hand has used Lotus, now Excel for sometime. However, he isn't very patient at sharing his expertise. But, I have brought a couple of projects home from the office to try to get him to help me. My problem is when I copy something to a disk, then take it back to my office and open it, it has embedded footers that were created on the computer at home. While this is no great disaster, I would prefer not to have my husband's name plastered on all my footers at work, because I used the computer at home. Hope you understand what I mean. Cannot find anything in the help, or elsewhere about deleting these (I hope I'm correct when I call them an embedded footer). It's pretty neat the way it creates the footer for you, but I want to change the name in the footer from my husband's to mine, or eliminate his name all together. You seem to be an expert, maybe you have a solution. Thanks!!

Posted by Ivan Moala on October 19, 1999 7:22 PM

Phyllise
You can change this manually or use a macro to do this.
Macro;

Sub UpDateFooter()
With ActiveSheet.PageSetup
.LeftFooter = application.username
End With
End Sub

Manual;
Click on "File"
Select "Page setup"
Click on the "Header/Footer" Tab
In the "Footer" dropdown list make your selection here.

regards

Ivan




Posted by Phyllis Keefer on October 20, 1999 4:55 PM

Ivan, thanks for your suggestion, don't know what the heck a macro is (some kind of shortcut?) but my son-in-law is a computer engineer, I'm sure he'll know. As far as the "manual" operation, tried that. Doesn't work. What I referred to as a embedded footer, is actually called a built-in footer. Well I'll try. Do you make house calls?

Thanks again!!!!!!!!!!!!!!!!!