VBA code that Stop Protection of Cell

[waqarqrl]

Hi All
Below mention code is highlighted rows and colomns and allow conditional formatting too.
but i want to add one more code for Protect the cell after every entry but when i apply that code it stop highlighting rows and colomns.
Help me out so that both code work together.


Code for Highlighting Rows and Colomns With Conditional Formatting

Please Login or Register  to view this content.

Code for Protecting Cell after each entry

Please Login or Register  to view this content.

Regards

[waqarqrl]

Can any body help me out?????

[waqarqrl]

Hello
One of my Friend Guide me through this code but following code doing some abnormal behavior blink the entire sheet abnormally.All Vba fox help me out. This code is about Highlighting, Protecting and allow Conditional Formatting

Regards

Please Login or Register  to view this content.

[arlu1201]

To stop the screen from blinking each time the macro runs, you need to use this at the start of your code

Please Login or Register  to view this content.

and this at the end

Please Login or Register  to view this content.

[waqarqrl]

Thanks Arlu1201

Can u please guide me where should i do this or If u please complete the code so i am great full to you.

Regards

[arlu1201]

This is your code after putting the screenupdating lines -

Please Login or Register  to view this content.

What issue are you facing with this code?

[waqarqrl]

Hi Arlu1201

I apply Your Code and it gives error on this line, whole line yellow.

Please Login or Register  to view this content.

and without this line sheet blink and stuck. I hope you will find the way.

Regards

[JapanDave]

It is not,

Please Login or Register  to view this content.

it is this,

Please Login or Register  to view this content.

You don't need the "s" at the end of application.

[waqarqrl]

Thanks Alot JapanDave

I did what you say remove S but it hung the excel and even my other workbook stuck.
I appreciate your concern. Need more your help to solve the problem.

Regards

[JapanDave]

Try this and see if it works.

Please Login or Register  to view this content.

Also, do you have another one of these event macros in the same module?

Please Login or Register  to view this content.

[arlu1201]

Thanks Dave. Typo at my end.

[waqarqrl]

Thanks Alot to all
My work has been done