2 questions...

[Bubba]

1. I have input the code to say when my spreadsheet was last saved but in order to make it visible to other users I want to put it at the top of my spreadsheet. Any idea how I can have it there and NOT print out. It is currently outside the page break preview but still shows on the print-out???


2. I have also managed to get to rename Excel but how can I have it run on start-up? I have placed the code in my hidden personal.xls worksheet but it don't wanna run on start-up!

Thanks for your help...

[Jay Petrulis]

On 2002-05-02 06:52, Bubba wrote:
1. I have input the code to say when my spreadsheet was last saved but in order to make it visible to other users I want to put it at the top of my spreadsheet. Any idea how I can have it there and NOT print out. It is currently outside the page break preview but still shows on the print-out???


2. I have also managed to get to rename Excel but how can I have it run on start-up? I have placed the code in my hidden personal.xls worksheet but it don't wanna run on start-up!

Thanks for your help...

Q1:
a) Modify the PrintArea section and exclude that range, if possible.
File>Page Setup>Sheet tab>PrintArea
or
b) Change the text of the cell to the background color (white) before printing. This could be done with a Workbook_Before_Print event macro.

Q2: Unsure of your request. Please restate.

[Bubba]

Thanks for your response - what would the code actually be to change the colour of the text in eg cell c1 to white in the beforeprint macro?

[Ivan F Moala]

On 2002-05-03 01:10, Bubba wrote:
Thanks for your response - what would the code actually be to change the colour of the text in eg cell c1 to white in the beforeprint macro?

something like;

CInd = [C1].Font.ColorIndex

'// change colour to white

[C1].Font.ColorIndex = 2

'//Print



'// Now restore colour back

[C1].Font.ColorIndex = CInd