Conditional formatting maybe

**jacobfromso** · 09-27-2007, 04:50 PM

does anyone know how I can lock or unlock a cell based on a condition of another cell?

**VBA Noob** · 09-27-2007, 05:12 PM

This event macro lets you edit B1 if A1 equals yes

See what you think

VBA Noob

**DCSwearingen** · 09-27-2007, 05:17 PM

What "Kind" of condition are you talking about?

Use the Worksheet_Change event

Please Login or Register  to view this content.

Or substitute

Please Login or Register  to view this content.

if you want to lock (or unlock) a cell that is not the active cell.

**VBA Noob** · 09-27-2007, 05:59 PM

or

Change B1 to your range.
and change Named range RestritiveRange to your cell or range

Please Login or Register  to view this content.

VBA Noob

**jacobfromso** · 09-27-2007, 06:23 PM

I should have added that I want to do this without a macro

**VBA Noob** · 09-27-2007, 06:27 PM

So why post under programming ??
Have you not read the rules below ??

VBA Noob

**jacobfromso** · 09-27-2007, 06:34 PM

Well - maybe an equation + conditional formatting???
My situation would be a piece of cake if conditional formatting would allow a cell to be lock or unlocked base on a condition

Conditional formatting maybe

LinkBack

Thread Tools

Display

Conditional formatting maybe

Will need to be VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions