In EXCEL,How do you control the access to SHEET2, based on a value

V

Vikranth

In EXCEL,How do you control the access to SHEET2, based on a value in SHEET1

EXAMPLE, if the value in one of the cell in sheet1 is > 80, then sheet2
should be enabled. Else, sheet2 should be disabled
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Search function 0
display a value from Sheet1-A1:A10 in Sheet2-B1 2
Table cross-check 0
If function across sheets prints value of cell 4
Automatically copying data from sheet1 to sheet2 2
Copy data automatically from sheet1 to sheet2 0
Click one cell sheet1, display all related recs on sheet2 1

Top