Hello,

I need to create different worksheets for my reporting and everytime I do so, while printing I had to type my standard header everytime. How do I make my standard (created by me) footer appear in the 'custom header' so that I dont have to type every time.

Regards... Fazil

Hi Fazil,

Thanks for the question. If you have to do a repeated action you can always record a macro to do the action for you and then you would just need to run the macro and the custom header would be put in place.

How you would do this is:-

1) Click Tools -> Macro -> Record a New Macro

Call it a relevant name and in this dialog box make sure you save the Macro in your Personal Macro Workbook, this means you can use it in a different workbook. You can also assign a keyboard shortcut to it.

2) Click OK and make sure the button next to the recording is depressed. (important step this)

3) Then go through the standard procedure of setting your Custom Header in the Page Setup section.

4) Finish recording.

5) You have recorded a macro to do that procedure and you can allocate that task to a button if you wish.

regards

Tracy

Thanks a lot Tracy. I just tried and it worked. It is very helpful, going to make my life a bit more easier.

Have a nice weeke-end.

Regards... Fazil

I was going to go on and show you how to allocate the Macro to a button, would that help?

Simply go to the toolbar buttons, right-click, and choose the option Customise and then you get the Customise dialog box up.

From there choose the Commands Tab, down to Macro and from the right hand side drag a custom button up on to your toolbar between two existing buttons.

Then once its there right click over it, (With the customise dialog box still open) and go to the option Assign Macro and you can pick your header macro that you have just created.

Close down the Customise Dialog box

Then all you need to do is click a button to perform your Macro

Ta Dah ....!!

Have a good weekend
Trace

Hi Tracy,

I dont know how to thank you for this...! This is just amazing..! A very special thanks to you...!

Regards... Fazil