If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Protect & Hide Sheet
Hi..
I have a few questions : 1. I have a sheet which has data in rows. How can I have the row highlighted in red if a particular cell A3 is blank for example whereas cell A1 has the required data in it? 2. Is it possible to protect only 1 sheet of a workbook? I have mutliple sheets in a workbook which has to be updated and mailed but I don't wan't the recepient to see any data on a particular sheet only. I can hide the sheet but anyone can open that sheet be unhiding that sheet. 3. I have a shared worksheet where alot of people update the sheet as required. How can I have a cell formatted so that only 8 digits can be entered? 4. In addition to above, how can I limit the length of characters allowed in a cell not to exceed 40 characters. Thanks, |
Thread Tools | |
Display Modes | |
|
|