The Vba that runs when the spreadsheet opens says to:
1) Refresh all data
2) Protect the sheets
3) Save the file
When 'I' open an Excel sheet, I do not know how Excel knows to 'wait'
for the refresh before issuing the Protect command. One thing appears
certain, it does NOT know to wait when MsAccess invokes the Excel
sheet.....
--
AndreLaplume
------------------------------------------------------------------------
AndreLaplume's Profile:
http://www.excelforum.com/member.php...o&userid=26805
View this thread:
http://www.excelforum.com/showthread...hreadid=400573