Once I define them in the spread sheet part, what are the requirements to be able to
use them in the VBA code? <<

Quite easy. For example, I have a "Settings" worksheet where I have a
number of named ranges so I can set values in the worksheet for the
macro that will be run:

If (Range("URL_Comics1") < 0) Then fMailThem ("Comics 1")
If (Range("URL_Comics2") < 0) Then fMailThem ("Comics 2")
If (Range("URL_Comics3") < 0) Then fMailThem ("Comics 3")
If (Range("URL_Daily") < 0) Then fMailThem ("Daily")
If (Range("URL_DailyTV") < 0) Then fMailThem ("Daily TV")
If (Range("URL_Portfolio") < 0) Then fMailThem ("Portfolio")
If (Range("URL_StockScreen") < 0) Then fMailThem ("Stock Screen")

I'm just using each cell as an indicator (0 or 1) of whether or not to
execute a particular function. Or, I have another section that looks
like this:

If wsG.Range("MSN_FYI") = 1 Then
Call Paste_Table("" & sData, pTicker, ...)
End If
If wsG.Range("MSN_Owners") = 1 Then
Call Paste_Table("" & sData, pTicker, ...)
End If
If wsG.Range("MSN_Analysts") = 1 Then
Call Paste_Table("" & sData, pTicker, ...)
End If
If wsG.Range("MSN_Highlights") = 1 Then
Call Paste_Table("" & sData, pTicker, ...)
End If