View Single Post
  #8   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
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