Protect Sheet - excluding selected cells

[Bebbspoke]

Hi Peoples,
I have a single sheet .xlsm which I wish to distribute... where users can ONLY modify a few specific cells... but they cannot access the formulae or macros which operate on the cells.
I have followed all "instructions" as found via Microsoft Office etc. but always end up with either a totally protected (locked) sheet or a sheet that is fully unlocked...
Please could someone fully detail the process sequence... including the "select" action on the Protection tab which at times appears to be tri-state
(i.e. blank, filled or ticked).
Thank you.

 

[Bebbspoke]

Hi Declamatory; - seems I'm still getting it wrong... I used the code mod as your post #10 suggested... but this runs as "single shot" (i.e. runs ONCE only) and then the macro facility is again inhibited until pw is entered... your comments please, ty.

 

[Declamatory]

Hi Bebbspoke,

The two lines of code are to unprotect the sheet and then protect it again once the macro has run.

Therefore the code to unprotect needs to be at the beginning of the code and the line to protect the sheet needs to be the last line of the code. (just before End Sub).

 

[Bebbspoke]

Hi Declamatory; - my sincere thanks for you patience! - my error was to insert the re-protect line in the wrong place... (I had copied your example exactly - without thinking of the remainder of the code).
I now have fully protected Sheet(s) & Workbook where Users may select their restricted operations... & the macros run but cannot be accessed.
Thank you indeed, Bebbspoke

 

[Declamatory]

Glad I could help.