CAS Authentication Macro for Excel

I need a Excel macro created that authenticates against a CAS (Central Authentication Server) server. The CAS server is already setup and work. I just need a macro create that I can run by attaching the macro to a button control that will log me into the CAS server. The CAS username and password can be hard coded into the macro. The macro needs to work with Excel 2003 or Excel 2007.