Glaswegian
Well-known Member
- Joined
- Oct 14, 2003
- Messages
- 1,487
My spreadsheet contains a number of cells where I've used data validation to present users with a choice of 4 options - they simply pick a letter and that is then printed when they eventually print the sheet. The cells will remain blank if not selected - this is dependent on the customer type etc. The workbook will be saved under a customer ref, so the validation cells will remain as originally chosen.
However, the next time the user opens the blank workbook(not the one saved with the customer ref) the validation cells should be blank/reset. Is it possible to do this?
However, the next time the user opens the blank workbook(not the one saved with the customer ref) the validation cells should be blank/reset. Is it possible to do this?