Highlighting particular cell

**muralidaran** · 02-09-2012, 10:30 AM

Two days earlier i have posted this same and code works perfectly as i required but the thing the code use to get error when the work sheet has been locked, so please some one try to help me in this issue.

Note: In my actual workbook all the work sheets has been locked with the same password with user interface only.

Thanks
Muralidaran.

**muralidaran** · 02-09-2012, 12:59 PM

Could someone help me please.

**Lifeseeker** · 02-09-2012, 01:15 PM

Originally Posted by muralidaran

Could someone help me please.

Hi,

I ran into the exact same problem before.

You need to tell me which columns or rows you want locked.

**muralidaran** · 02-10-2012, 08:42 AM

The complete sheet has been locked.

**Lifeseeker** · 02-10-2012, 08:55 AM

Ok, you want the entire sheet to be locked, but with locked sheet what actions do you want to allow to be done on the sheet?

When I was troubleshooting, I remember I had to allow and disallow certain actions.

If the entire sheet is locked, then the worksheet_selectionchange may not work because how worksheet_selectionchange works is that it needs to be triggered by an action done on the worksheet.