When I protect the sheet, it changes how i want the work to be

[Pasadu]

Sir, I have attached the File. It works just as i want when sheet is not protected. But immediately i protect the sheet, it gives me "Run time error 1004". I still want the sheet to be protected and be able to maintain the page as it is. Thank You.

 

[Marc L]

As it depends where the error occurs but you forgot to indicate it …​

​

Anyway, unprotect the sheet in your VBA procedure just before then protect the worksheet just after …​

​

 

[vletm]

Pasadu
Use userinterfaceonly -option with Protect.

 

[Pasadu]

Thank you for your response. I tried the user interface only option but could not work. When i protect the sheet and fill L5, when i press "tab" for it to go to M5, it gives me error. When the sheet is not protected, no error. When it is protected, error. I have attached the file please.

 

[vletm]

Pasadu
Why You didn't use that my solution as well as a sample for that?
.. then user could do needed ... eg to edit only those cells which You've named.

 

[Pasadu]

Sorry i don't know much about Macro. Please guide me through as to how to do it please. Thank you

 

[vletm]

Pasadu
... I see

 

[Pasadu]

Thank you sir. I understand the work you've built for me. I will do my part to make some adjustments. This is enough for me to complete my task. Thank you for your time and assistance. I appreciate it.