Input password or open the sheet as "Read only
 

Hi,
I've created an Excel sheet that ,when opened,asks the user to input his
password or to open the sheet as "Read only",this is fine...
I need to add in the Close event of this sheet a VB code to cancel this
event,so while the sheet is closed,it can be updated through an Access
database that outputs some of its tables in this sheet,but again when any
user tries to open it,it asks him to type the passord or to open the sheet as
"Read only",
Does it make sense?