Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep a picture in Excel 97 page footer/header?
Any body Pls., tell me "How to keep a picture in Excel 97 page footer or
header? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep a picture in Excel 97 page footer/header?
I don't think it's possible in Excel 97. The Microsoft Knowledge Base has an
article about how to do this, and it says it applies to Excel 2000 and Excl 2002. It doesn't mention Excel 97. On Sun, 10 Oct 2004 19:29:02 -0700, "Umesh" wrote: Any body Pls., tell me "How to keep a picture in Excel 97 page footer or header? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep a picture in Excel 97 page footer/header?
Umesh
You could use the Worksheet_Change() Event such as Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("A1")) Is Nothing Then Range("S1").Select End If End Sub This moves the selection to S1 if the data in A1 changes HTH Nick Hodge "Umesh" wrote: Any body Pls., tell me "How to keep a picture in Excel 97 page footer or header? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep a picture in Excel 97 page footer/header?
Hi, Nick:
Did you reply to the wrong message? Umesh's subject is "How to keep a picture in Excel 97 page footer/header?" Myrna Larson On Sun, 10 Oct 2004 21:09:01 -0700, "Nick Hodge" wrote: Umesh You could use the Worksheet_Change() Event such as Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("A1")) Is Nothing Then Range("S1").Select End If End Sub This moves the selection to S1 if the data in A1 changes HTH Nick Hodge "Umesh" wrote: Any body Pls., tell me "How to keep a picture in Excel 97 page footer or header? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep a picture in Excel 97 page footer/header?
Myrna,
Do you have a link to this article ? Thanks NickHK "Myrna Larson" wrote in message ... I don't think it's possible in Excel 97. The Microsoft Knowledge Base has an article about how to do this, and it says it applies to Excel 2000 and Excl 2002. It doesn't mention Excel 97. On Sun, 10 Oct 2004 19:29:02 -0700, "Umesh" wrote: Any body Pls., tell me "How to keep a picture in Excel 97 page footer or header? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep a picture in Excel 97 page footer/header?
I can't say what Myrna's specific link is, but I believe she misread it (or
it was mistated) if it says you can do this in Excel 2000. To the best of my knowledge, this is supported in xl2002 and later: http://support.microsoft.com/default...71&Product=xlw XL2000: Unable to Insert Image/Picture into Header or Footer http://support.microsoft.com/default...64&Product=xlw HOW TO: Insert a Picture into the Header or Footer in Microsoft Excel 2002 http://support.microsoft.com/default...18&Product=xlw HOW TO: Insert a Picture into the Header or the Footer in Excel 2003 http://support.microsoft.com/default...05&Product=xlw XL2002: Picture in Header or Footer Is Not Added to All Grouped Worksheets http://office.microsoft.com/en-us/as...px?Product=xlw Insert a graphic in a header or footer -- Regards, Tom Ogilvy "NickHK" wrote in message ... Myrna, Do you have a link to this article ? Thanks NickHK "Myrna Larson" wrote in message ... I don't think it's possible in Excel 97. The Microsoft Knowledge Base has an article about how to do this, and it says it applies to Excel 2000 and Excl 2002. It doesn't mention Excel 97. On Sun, 10 Oct 2004 19:29:02 -0700, "Umesh" wrote: Any body Pls., tell me "How to keep a picture in Excel 97 page footer or header? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep a picture in Excel 97 page footer/header?
Tom,
Thanks for those. I've always understood this not to be possible in XL2000, but would have been interested to be proved wrong. One link does state "New functionality introduced with Excel 2002..", so I guess we are out of luck. NickHK "Tom Ogilvy" wrote in message ... I can't say what Myrna's specific link is, but I believe she misread it (or it was mistated) if it says you can do this in Excel 2000. To the best of my knowledge, this is supported in xl2002 and later: http://support.microsoft.com/default...71&Product=xlw XL2000: Unable to Insert Image/Picture into Header or Footer http://support.microsoft.com/default...64&Product=xlw HOW TO: Insert a Picture into the Header or Footer in Microsoft Excel 2002 http://support.microsoft.com/default...18&Product=xlw HOW TO: Insert a Picture into the Header or the Footer in Excel 2003 http://support.microsoft.com/default...05&Product=xlw XL2002: Picture in Header or Footer Is Not Added to All Grouped Worksheets http://office.microsoft.com/en-us/as...px?Product=xlw Insert a graphic in a header or footer -- Regards, Tom Ogilvy "NickHK" wrote in message ... Myrna, Do you have a link to this article ? Thanks NickHK "Myrna Larson" wrote in message ... I don't think it's possible in Excel 97. The Microsoft Knowledge Base has an article about how to do this, and it says it applies to Excel 2000 and Excl 2002. It doesn't mention Excel 97. On Sun, 10 Oct 2004 19:29:02 -0700, "Umesh" wrote: Any body Pls., tell me "How to keep a picture in Excel 97 page footer or header? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help inserting picture into header/footer | New Users to Excel | |||
in excel using page numbers without using header and footer | Excel Discussion (Misc queries) | |||
How do I hide the header and footer on page 1 in Excel? | Excel Discussion (Misc queries) | |||
How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions | |||
Remove header/footer from Excel first page? | Excel Discussion (Misc queries) |