I want to be able to run a macro that password protects a sheet, but I want to allow certain editing options. Current I use
This allows users to select unlocked cells & select locked cells.![]()
Sheets("Master Sheet").Protect Password:="secret"
I would like to allow users the following
Select locked cells
Select unlocked cells
Format rows
Delete rows
Is there any way to do this in a macro?
Thanks
Bookmarks