Hi,
I just introduced myself as a new member; here's my problem -

Our club uses an Excel accounts workbook with a dozend sheets. Created with MS Excel 2011 for Mac, ver 14.6.0.
All sheets are password protected.
Sheet 1 allows the User to enter names, addresses etc into the relevant cells.
Other sheets are for different months, with unlocked cells to accept numbers.

I want the user to click on a couple of macros, to 'lock' the cells in sheet 1 or unlock them, without having the password to unprotect the sheet (and mess it up).

Excel 2011 no longer has the function "Allow Users to Edit Ranges".
How can I solve this?
Opi