I am trying to create code to remember the SQL Username and Password so that
when all users connect to my excel workbook its connects to the SQL without
have to type in the username and password everytime.

I am using Excel 2003 SP2 and I have created many queries that are linked to
a live SQL Database, but when a standard user wants to open the excel sheet
it won't allow them to connect.

Please help this is proving to be a nightmare..