Auto Open A Protected Workbook

[SchoolDataMan]

Hi,

I have workbook which needs to be password protected.

When staff open the work book they are presented with a form to complete and upon saving, their answers are saved to a sheet and the file closes.

I have password protected the workbook to stop staff opening the workbook, and making tabs visible to access the data. However I cannot find any code which autocomplete the password each time the file is opened and allows the form to be completed.

Any help would be greatly appreciated.

Thank you

James

 

[Warship]

Look at: Workbooks.Open