Lock/Unlock Spreadsheet in VBA

[pancaked]

Hi,

I've got a spreadsheet with 20+ worksheets and many VBA scripts. I have set up basically a "control panel" where users can run any of the macros to interact with the spreadsheet. My intention is that they use these macros only and do not alter any of the cells the spreadsheet.

I'd like to lock all the cells in the entire spreadsheet (well, most cells, with a few exceptions) so they cannot be altered manually -- but the macros would still need to be able to alter cells.

Is there a simple or elegant way to accomplish this?

Thanks!

 

[starl]

protect the sheet programmatically with:

Worksheets(sheetname).protect userinterfaceonly:=true

this allows code to change values on sheets, but not the user. Even if the cell is locked.
note that if you want filtering to work, you'll have to add more arguments. Just look up Protect in help. Or record the settings you want and then add userinterface