VBA Code For Excel Help Required

[chetan_hm2]

Hi,

I am using Worksheet level event for clearing off cells content in excel worksheet based on certain value. I am unprotecting the workbook in Workbook Open Event and writing the code for clearing off cell contents in a very particular excel sheet and then protecting it again at the end of the macro in Worksheet level Open Macro actually.

Can you please guide me why it is giving screen flickering and how to avoid it?
Sometimes Workbook is getting unlocked also due to workbook open or Activate Event at Worksheet level.

Also, another requirement is do clear off Cell Contents in say A2 based on particular selection of dropdown in Cell A1 . How to do it without using any macro code or Worksheet level event

How to do it?



Regards,
CompuStrenghth