Vba UserForm not returning error message when working on a sheet with locked cells

[nikolaikolev]

Dear,
how can i make VBA UserForm not returning error message when working on a sheet with locked cells
Each time i execute the form for a sheet with locked cells i get error message as in the attached file.

 

[Fluff]

You will need to unprotect the sheet before doing anything to it & then reprotect it at the end.
You can use the macro recorder to get the code if needed.

 

[nikolaikolev]

I do not know how to use macro recorder.
How will the code would look like ?

 

[Fluff]

Have a look here to see how to use the recorder.
When you have started it, just unprotect the sheet & then reprotect, stop the recorder & you have the code.

 

[nikolaikolev]

Have a look here to see how to use the recorder.
When you have started it, just unprotect the sheet & then reprotect, stop the recorder & you have the code.

Thanx pal. Can you provide a link with some info on what is macro recorder and how to use it ?

 

[Fluff]

Sorry forgot to add the link Excel Macro Recorder