View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mark C via OfficeKB.com[_2_] Mark C via OfficeKB.com[_2_] is offline
external usenet poster
 
Posts: 3
Default Date Inserted in header

Works Great!!

When I had tested it I had some text in the center header.

Thank you very Much!!!!

Mike Fogleman wrote:
Mark: That is exactly what this code does. You will input the date once in
the inputbox. The IF statement checks the length of the center header string
and if it is greater than 4 characters, does nothing and skips to End If.
For example if the header displays 2006, then the center header string is
"&20 2006". including the space, that is 8 characters. Since 8 is 4,
nothing happens and the 2006 stays intact. If there are 4 characters or less
then the header is empty ("") or only has the font size property but no text
("&20 "). If that is true, then the input box will ask you to enter a date,
which is then put into the header. The next time the macro is run, it will
see 8 characters in the header and do nothing.
The first time you run this macro the center header must be empty. If you
still have the "4" there, clear it out manually in the View/ Header Footer
menu.

Mike F
Is There a way to make it so that the date will not change. The way it
seems

[quoted text clipped - 70 lines]

Mike F


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200602/1