| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation to stop workbook closing
One of my users has created a workbook for recording data in lists using data
validation to make the drop-down lists. She wants to prevent the spreadsheet from being closed down if certain (other) cells have not been populated with some text. Is this possible through normal tools without macros? I've been scratching my head and searching help and this forum without success. We have just started using XL2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation to stop workbook closing
only a macro could do that.....
-- paul remove nospam for email addy! "Jonathan" wrote: One of my users has created a workbook for recording data in lists using data validation to make the drop-down lists. She wants to prevent the spreadsheet from being closed down if certain (other) cells have not been populated with some text. Is this possible through normal tools without macros? I've been scratching my head and searching help and this forum without success. We have just started using XL2003. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation to stop workbook closing
Thank you for your very fast response Paul--I was afraid that would be the
case! "paul" wrote: only a macro could do that..... -- paul remove nospam for email addy! "Jonathan" wrote: One of my users has created a workbook for recording data in lists using data validation to make the drop-down lists. She wants to prevent the spreadsheet from being closed down if certain (other) cells have not been populated with some text. Is this possible through normal tools without macros? I've been scratching my head and searching help and this forum without success. We have just started using XL2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| prohibit closing a workbook | Excel Discussion (Misc queries) | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Hybrid Mode
