Locking Editable Cells in excel

[jvet4]

I have an excel workbook using the Solver add-in. In my workbook, I am using solver to optimize a group of cells, however I do not want the user to be able to modify the cells. When I try to lock the sheet and run the solver macro, I get an error saying the sheet is protected therefore read-only. I have tried to lock the sheet allowing the user to edit objects/scenarios but that does not to work. Is there a way to lock a worksheet so that a VBA script can still edit cells, however the user cannot?

 

[SteveBausch]

You'll need to add some unprotect/protect code to your macro.

ActiveWorkbook.UnProtect "ThePassword"
........
'your code here
.............
ActiveWorkbook.Protect "ThePassword"

 

[SteveBausch]

OOps!, that code is for the workbook, you may not want that.

I meant to say:

ActiveWorksheet.UnProtect "ThePassword"
........
'your code here
.............
ActiveWorksheet.Protect "ThePassword"

 

[xlbo]

There is indeed - you need to put this code in your workbook_OPEN event as it is reset when the workbook is closed

Sheets("Sheetname&quot.protect userinterfaceonly:=true

This will mean that code can run unhindered but users cannot edit locked cells Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde