Macro to password protect with some editing options

[BridgeCat]

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

Please Login or Register  to view this content.

This allows users to select unlocked cells & select locked cells.

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

[royUK]

Record a macro to start with

[TMS]

If you record a macro while applying the settings you want, you get:

Please Login or Register  to view this content.

So, you should be able to edit to:

Please Login or Register  to view this content.

Regards

[BridgeCat]

Wow thats embarrassing that I didn't think to just record the macro haha! Thanks guys!

[TMS]

You're welcome. Thanks for the rep.