I have two problems relating to Excel which I need help with:

1) I have created a spreadsheet for users to record their monthl
income details. I have added a splash screen which is viewable for
seconds when the document is opened giving the user additiona
information.
I want to give the user the option of switching this off when they hav
viewed it so that is doesn't pop up every time they open the workbook a
it could become annoying. Does anyone have any idea how I could d
this?

2) When printing an individual sheet I want to be able to create in th
header the name of the person or company using the sheet automaticall
without the user having to go through setup, header and type thei
details in, as I would like to make the workbook as user friendly a
possible and can't be sure that the user would have much experienc
with Excel. Is there any way to do this? The person filling in th
sheet would complete their details on page 1 which is then linked t
the other pages, so the company or person name would be in cel
reference C3

Any ideas?
Thank you in advance.
Rub

--
Rub
-----------------------------------------------------------------------
Ruby's Profile: http://www.excelforum.com/member.php...fo&userid=3706
View this thread: http://www.excelforum.com/showthread.php?threadid=56861