Excel 2000, headers and hiding text

[Pushkinwow]

Let me first explain the situation.

Thanks to this forum I was able to figure out how to manipulate excel to enable a header with a picture in it with excel 2000 (if only my work would update!)

The purpose of this was to create an appropriate template to be used in excel for all of our documentation. It works great for any document that needs to be printed. My problem arises when the document is only used electronically the information in the header (date, name of department etc) does not appear on what you see.

My idea was to write the information contained in header into the document itself (in the area where the header would appear when printing) and to somehow render that text unprintable. However I do not know how to do this.

So basically I need a way to remove text before printing, or to tell excel that when printing it should not print certain cells.

Is this possible or are there other ways around this problem. Feel free to ask for clarification as I think I may have muddled the explanation

 

[Gettingbetter]

Put it in your spreadsheet in an TextBox. These allow both text and pictures. Then In the textbox properties remove the border and colour. Also in the propeties you can untick the print object option.

Hope this helps

 

[Pushkinwow]

I think it does - quick follow up though. If I need the information in the textbox to update (the date needs to change) where do I insert this code? (I am not overly familiar with VB)

I have the code from the header but I assume I can just put that code into the text field of the textbox and it will then update - can I somehow but this code into the worksheet open function?