I have Workbook with both Sheet/workbook is protected. I have a code to lock/disable certain range of cells when the drop-down value "no" And unlock/enable when value of drop down is "yes" Whereas, drop-down value and cells I would like to disable are on different sheets.

Dropdown on "Main Sheet" Range of cells on "Sub Sheet"
I also need to throw a prompt to user when he clicks on protected range and when the value is set to "No".

I am using following code on "Main Sheet"
Please Login or Register  to view this content.
Following code on "Subsheet"
Please Login or Register  to view this content.
But my concern is Its throwing prompt when cells are unlocked/enabled. I want it to throw a prompt when cells are locked/disabled. Please help