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