Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lock tab in sheet 2 until cell in sheet one is completed
lock sheet 2 tab until information is put into sheet one cell
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lock tab in sheet 2 until cell in sheet one is completed
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lock tab in sheet 2 until cell in sheet one is completed
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 On Sun, 20 Nov 2005 23:31:05 -0800, john tempest wrote: "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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lock tab in sheet 2 until cell in sheet one is completed
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 On Mon, 21 Nov 2005 12:14:40 -0800, Gord Dibben <gorddibbATshawDOTca wrote: John 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 On Sun, 20 Nov 2005 23:31:05 -0800, john tempest wrote: "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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lock tab in sheet 2 until cell in sheet one is completed
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 "Gord Dibben" wrote: 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 On Mon, 21 Nov 2005 12:14:40 -0800, Gord Dibben <gorddibbATshawDOTca wrote: John 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 On Sun, 20 Nov 2005 23:31:05 -0800, john tempest wrote: "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text from one sheet cell to appear in another sheet cell | Excel Worksheet Functions | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions |