Making a spreadsheet read only and password protected

[BajanPOET]

Is there a way to force an Excel spreadsheet to save as read only but need a password to make it read-write so that only management can change the data in the spreadsheet? All staff should be able to view the spreadsheet but only the director has permission to change anything.

What? Who? ME????

 

[PHV]

Have a look at the Excel.WorkBook.WritePassword property and/or the WriteResPassword named argument of the Excel.WorkBook.SaveAs method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BajanPOET]

Yeah I saw it after I posted... It's helped me out - thanks.

What? Who? ME????