Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a formula to make a cell contents blank upon opening the worksheet?
I have a worksheet with client's confidential information. Cell A1 has a dropdown list of ALL of my client's names so that when I select a client's name, it shows their information in the other cells in the worksheet. Currently, whenever I open this workbook, clients are able to see another client's information (the client who's information I looked at last). What I would like, is to have cell A1 contents become blank whenever I open the worksheet. Is this possible? Much thankyou's in advance. I |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I prevent excel from opening with a blank worksheet? | Excel Discussion (Misc queries) | |||
Stop opening a blank worksheet | Excel Discussion (Misc queries) | |||
Open Excel App without a blank worksheet opening | Excel Discussion (Misc queries) | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions |