Protect Cells While Letting Macros Edit Them

Hello there, I want to protect cells to prevent a user from editing them, however I want to allow macros to be able to change the cell contents if needed (while the sheet is still protected). Is there any way I can do this? Basically, I have a macro that adds 1 to the number value in a cell when activated and I want that to be able to work while the cells are protected from user edits. If anyone would be able to assist with this it would be greatly appreciated.

You can unprotect the sheet in the macro, edit the cell and then protect the sheet.

Thanks for the quick reply, I never thought about that. Do you know what code I would have to use in order to do it?

Nevermind, I found out how to do it after. Thanks for your suggestion.

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.