lock tab in sheet 2 until cell in sheet one is completed
"Gord Dibben" wrote:
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
On Sun, 20 Nov 2005 01:02:01 -0800, john tempest
wrote:
"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
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
|