J
john tempest
lock sheet 2 tab until information is put into sheet one cell
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
J
john tempest
Gord Dibben said: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
G
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
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
J
john tempest
thankyou, john tempestGord Dibben said: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.
a
G
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
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
G
Gord Dibben
Sorry John.
Post a little confusing.
Refers to you emailing the finished time sheet to wherever, not you emailing
me your address.
Gord
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
J
john tempest
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
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