View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Locking/Unlocking cells upon condition

Jerry and Brett

You seem to have resolved the problem.

Brett.........for more information, Chip Pearson has good coverage on Events at
his site.

http://www.cpearson.com/excel/events.htm

Scroll down to see "enabling and disabling events"


Gord

On Sat, 10 Mar 2007 20:21:15 -0800, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

I know I speak for myself, and I think maybe for Gord also when I say

Thank you for the Thank you.

All's well that ends well, and it was probably a learning experience for all
concerned. Sometimes you just have to turn around, make three left turns
instead of a single right turn to get to the end of the block -

"Brettjg" wrote:

JERRY! YEEEEEEEEEEEEeeeeeeeeeeeeeeeeeeeeaaaaaaaaaaaaaaaaa hhhhhhhhhhhhh!

In the end there's no ThisWorksheet, no Activesheet, just specific names.
I'm using the original code again, but like this. What a slog. Thanks very
much for your help and persistance.

Brett