View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default lock tab in sheet 2 until cell in sheet one is completed

john

I assume there is a question here but "lock sheet 2 tab" means what?

Don't allow it to be selected?

Have it hidden until certain cell(s) in sheet 1 are filled?

Protect sheet 2 until as above?

More detail please.


Gord Dibben Excel MVP

On Sat, 19 Nov 2005 06:01:01 -0800, john tempest
wrote:

lock sheet 2 tab until information is put into sheet one cell