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



"Gord Dibben" wrote:

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


what i need to do is hide sheet 2 until certain cells in sheet 1 are filled in, or somehow lock the tab on sheet 2 until certain cells in sheet 1 are filled in