I need to protect my sheet from users making changes to certain cell
but I am encountering a problem with my macro buttons.

The button makes changes to cells that I have locked and protected fro
users. When i protect the sheet the button cannot make the changes an
gives an error.

Is there a way to allow the macro to do its work on locked cells whil
still protecting the cell from user changes

--
Message posted from http://www.ExcelForum.com

Your macro will need to unprotect the sheet, make the changes then
re-protect the sheet.

ActiveSheet.Unprotect Password:="password"

ActiveSheet.Protect Password:="password"

Set the command button, TakeFocusOnClcik to False

Cheers
Nigel

"DangerMouse114 " wrote in
message ...
I need to protect my sheet from users making changes to certain cells
but I am encountering a problem with my macro buttons.

The button makes changes to cells that I have locked and protected from
users. When i protect the sheet the button cannot make the changes and
gives an error.

Is there a way to allow the macro to do its work on locked cells while
still protecting the cell from user changes?


---
Message posted from http://www.ExcelForum.com/

The code assigned to the buttons need to unprotect the
target cells, change their values and then re-protect them


Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I need to protect my sheet from users making changes to
certain cells
but I am encountering a problem with my macro buttons.

The button makes changes to cells that I have locked and
protected from
users. When i protect the sheet the button cannot make
the changes and
gives an error.

Is there a way to allow the macro to do its work on
locked cells while
still protecting the cell from user changes?


---
Message posted from http://www.ExcelForum.com/

.

Thanks Nigel! Worked like a charm!




Nigel wrote:
*Your macro will need to unprotect the sheet, make the changes then
re-protect the sheet.

ActiveSheet.Unprotect Password:="password"

ActiveSheet.Protect Password:="password"

Set the command button, TakeFocusOnClcik to False

Cheers
Nigel

"DangerMouse114 "
wrote in
message ...
I need to protect my sheet from users making changes to certai
cells
but I am encountering a problem with my macro buttons.

The button makes changes to cells that I have locked and protecte
from
users. When i protect the sheet the button cannot make the change
and
gives an error.

Is there a way to allow the macro to do its work on locked cell
while
still protecting the cell from user changes?


---
Message posted from http://www.ExcelForum.com/
* :) :) :) :) :( ;

--
Message posted from http://www.ExcelForum.com