View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.misc
Brettjg Brettjg is offline
external usenet poster
 
Posts: 295
Default Locking/Unlocking cells upon condition

Yes Gord, thanks for your help. Sorry mate, I didn't see this last post of
yours until just now. It seems to me (from Jerry's response) that you guys
don't get much thanks, and that sucks if it's the case. Your a bunch of
lifesavers. Cheers, Brett

"Gord Dibben" wrote:

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