Excel 2013 - Adjust Excel Sheet Protection options to allow users to make some changes

You need to reset the permissions when you re-protect the worksheet. Use the macro recorder to get the basic code...

Hi There,

Thank you, that makes sense. I used macro recorder and the following code was the result of setting these options:

Please Login or Register  to view this content.

Now if I modify my existing macro to include this, will this work? The formatting does look a bit strange, does this need to be changed?

Please Login or Register  to view this content.

Thanks so much. I will test out this updated Macro and let you know the results.

Hi There,

I have now tested the Macro and it is running perfectly across all Excel workbooks except 1.

1 Excel Workbook is giving a run time error as per below. Is there anything I can look at to prevent this from occuring?

Runtime.PNG

When selecting debug, it is selecting this:

Please Login or Register  to view this content.

Full code:

Please Login or Register  to view this content.

Thanks for your suggestion. I tried adding this code and testing, but there is still an issue. The latest run time error references this as the problem code:

Please Login or Register  to view this content.

Hi There, yes that makes sense. Thank you very much. I have uploaded the spreadsheet that has the issue. I would really appreciate assistance with this. Macro is working well, just this 1 workbook doesn't like it.

Thank you very much for pointing out this issue. I had not noticed this. I will be working through and deleting these and will let you know if it fixes the crashing.

Hi There,

I have gone through and cleared out these weird unused cells and everything is perfect. Thanks so much for all your support. I am marking this as solved.