How can I make my 'master' worksheet read-only whist allowing macro input.

Hi,

I have a worksheet which I would like to make read-only for user input. However I would like the sheet to allow input from my macros. Is this possible? I have tried to manually protect the sheet, but this stops the input from my macros.

Any help on this subject would be great.

Many thanks

Alex

Good evening gilko86

You could experiment with the UserInterfaceOnly flag with your protection, but I personally think that's not ideal.
The easiest way is to code your macros so that they unprotect the sheet, make the changes and then reprotect the sheet.
If you use Application.ScreenUpdating=False at the start of your macro, it is virtually undetectable to the user.

HTH

DominicB