Ruby,
I am assuming this is one workbook used by multiple people. If that
the case, the only way I know how to switch your splash screen on/off i
to store the value in the registry. There are 3 built-in functions tha
are simple to use: SaveSetting, GetSetting and DeleteSetting. Fo
example http://j-walk.com/ss/excel/tips/tip60.htm. If they deselec
the checkbox, create a key using SaveSetting with a value in it (sa
0). Add to your startup code to check that key using GetSetting. I
the key is not set, then display the splash screen.
If this workbook is tailored to each individual you could just read
cell value before displaying the screen.

As for the header, you can use:

Sub FillHeader()
Dim wkSht As Worksheet

For Each wkSht In Worksheets
With wkSht.PageSetup
.LeftHeader = ""
.CenterHeader = wkSht.Range("C1")
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
Next

End Sub

This sets it up for the center header. It goes through each workshee
in the workbook

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