Hi All

On my sheet 'Data' I have a data validation drop down menu that contains 7
'options' for the user to pick. Each option is linked to a seperate marco and
is run when the option is chosen .

What I would like is some code that will protect the following sheet names
when the workbook is first opened..

Data
Sheet 5


Then each time an option is chosen from my validation list on sheet 'data' I
want both the above sheets to be unprotected, and finally when the macro is
run and complete then both sheets to be protected again. Oh and when the
workbook is closed then unprotect the sheets once more.

Any help with code and exactly where to place it so that it works would be
very grateful

thanks