Sunday, October 11, 2020

Learn How to Add Header and Footer Date in Excel using Macro | Learn How to Add Header and Footer Date in Excel using Macro

 Learn How to Add Header and  Footer Date in Excel using Macro | Learn How to Add Header and  Footer Date in Excel using Macro

  Do the following steps using VBA Code.

1. Open active excel sheet 

2. Press Alt + F11 and Visual Basic Application window will open.

3. Go to Insert Menu and select new Module.

4. In new Module insert the below VBA Code and save it.

5. Before do the above process, excel sheet must save as Macro-Enabled.

6. To do Macro Enabled, open Excel Sheet and Click on the Office Button which is at left top corner on excel sheet.

7.  Select Save as and again select Macro Enabled Worksheet and then save it.
 
Sub DateInHeader()
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = "&D"
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
End Sub

No comments:

Post a Comment

Lion King 2019 Telugu Movie | Lion King Telugu Movie | Lion King Telugu Version Movie

  Lion King 2019 Telugu Version Movie has been released and running successfully in theaters. Telugu Top Heros J agapathi Babu and Nani g...