Georged405
New Member
- Joined
- Feb 24, 2015
- Messages
- 1
Hi everyone,
I just stumbled upon a topic which seems to not have been discussed yet, although it is very ineteresting to me.
Situation is: I have a file (an order form I created as an Excel sheet) for which I threw together a rather beginner level of VBA code. Task was to make four consecutive fields (D3 to D6) mandatory, so the user MUST fill them, otherwise they couldn't save the file.
VBA code is done, works as a charm, but... now I can't save the file either without writing something into those fields. But if I do, and I save and send it out to the users, they are not forced to fill the fileds with their OWN data because there is already something (i.e. the example text I put) in them.
How would you solve that paradox? How can I save the file one time for future use with those fields empty, but from the next use onwards they would be mandatory?
Hope my problem is somewhat clear... and thanks in advance!
I just stumbled upon a topic which seems to not have been discussed yet, although it is very ineteresting to me.
Situation is: I have a file (an order form I created as an Excel sheet) for which I threw together a rather beginner level of VBA code. Task was to make four consecutive fields (D3 to D6) mandatory, so the user MUST fill them, otherwise they couldn't save the file.
VBA code is done, works as a charm, but... now I can't save the file either without writing something into those fields. But if I do, and I save and send it out to the users, they are not forced to fill the fileds with their OWN data because there is already something (i.e. the example text I put) in them.
How would you solve that paradox? How can I save the file one time for future use with those fields empty, but from the next use onwards they would be mandatory?
Hope my problem is somewhat clear... and thanks in advance!
