lock tab in sheet 2 until cell in sheet one is completed

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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



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

 

[Gord Dibben]

John

You would have to use VBA to do what you want.

Hide all sheets except a message sheet that states "You have disabled macros
and rendered this workbook unusable. Close and re-open with macros enabled".

If user chooses to enable macros, make all sheets except Sheet2 visible.

Have worksheet event code in Sheet1 that will make Sheet2 visible when/if
users fill out the appropriate cells.

Question.........do you want the range of cells in Sheet1 cleared of content
each time the workbook is closed or will they remain filled in?

i.e. What are you doing on Sheet2 that prompts you to have it hidden until
data is filled on Sheet1?

I can send you a workbook doing the above if you wish to see an example.

OR do a google search on "force users to fill in cells"

NOTE: in all cases, you would be dependent upon users not being savvy enough
to be able to break any password you set on the VBA project.


Gord Dibben Excel MVP

 

[Guest]

John

You would have to use VBA to do what you want.

Hide all sheets except a message sheet that states "You have disabled macros
and rendered this workbook unusable. Close and re-open with macros enabled".

If user chooses to enable macros, make all sheets except Sheet2 visible.

Have worksheet event code in Sheet1 that will make Sheet2 visible when/if
users fill out the appropriate cells.

Question.........do you want the range of cells in Sheet1 cleared of content
each time the workbook is closed or will they remain filled in?

i.e. What are you doing on Sheet2 that prompts you to have it hidden until
data is filled on Sheet1?

I can send you a workbook doing the above if you wish to see an example.

OR do a google search on "force users to fill in cells"

NOTE: in all cases, you would be dependent upon users not being savvy enough
to be able to break any password you set on the VBA project.


Gord Dibben Excel MVP




this workbook is a timesheet. what i am trying to do is make people fill out all the infomation on the time sheet before it can be e mailled. sheet 1 is the entry sheet where the weekly information is recorded and transferred to sheet 2 using macros. sheet 2 is the timesheet which can then be moved and emailed.workbook with an example would be very helpful.

thankyou, john tempest
a

 

[Gord Dibben]

John

I will assume you will be emailing just Sheet2, not the entire workbook.

email me directly with your proper email address and I'll send you an example
workbook.

To get my un-munged email address change the DOT and AT to appropriate
punctuation.


Gord

 

[Gord Dibben]

Sorry John.

Post a little confusing.

I will assume you will be emailing just Sheet2, not the entire workbook.

Refers to you emailing the finished time sheet to wherever, not you emailing
me your address.


Gord

 

[Guest]

gord
i have tried your code. in the "timefill" i have put the range C2:C5. i get
an error message: runtime error 9. subscript out of range
thankyou john