Hello Everyone,

Using excel 2003.

Quick Question - I have an excel spreadsheet that is "sheet
protected". I have an ODBC connection that refreshes the spreadsheet
when it is opened, so in the On_Open event of the
workbook I have code to unprotect the sheet so the refresh will work.

Here's the question. Where in the world can I place the code to
reprotect the workbook after the
user clicks the "Enable automatic refresh' button. Any help
appreciated. Thanks Ray