Thanks for the reply Steve
This posting is quite long winded......I have tried to explain myself....if
my questions are going on a bit and you don't want to post any further I will
understand.....
Your Code:-
Sheet1.PageSetup.CenterFooter = "&""Times New Roman,Regular""&16 " & _
Format(Now, "dd/mm/yyyy HH:MM:SS") & " - Requested by MASTER - Page 1"
Worked great and displayed the footer as I want it.
What I can't seem to figure out is......what syntax determines the displayed
text...I have been displaying the & etc...

For example I have put a label on the UserForm to reflect what's hapenning
in the footer.............
Let lblDisplayFooter.Caption = Sheet1.PageSetup.CenterFooter
End Sub

Using your code above displays everything in the label caption...... for
example
&"Times New Roman, Regular&"16......is all displayed...
I like this......I can see the formatting description on the userForm label,
and print the correct footer without the description........nice
touch...but....to help me understand....

Can you explain briefly how I reason this out.....for example How would I
change the label code to display exactly as the footer....is it the syntax
that's different?

Any help would again be much appriciated, as I have spent some time trying
to work this out, everytime I think I have a grasp of something....you know
the story, eh?

"stevebriz" wrote:

Try this

Sheet1.PageSetup.CenterFooter = "&""Times New Roman,Regular""&16 " &
Format(Now, "dd/mm/yyyy HH:MM:SS") & " - Requested by MASTER - Page 1"