Macro Question
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 |
Macro Question
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/ |
Macro Question
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/ . |
Macro Question
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 |
All times are GMT +1. The time now is 06:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com