J
Jaz
I have an excel template file that has drop down boxes for a user to pick
certain options.
The user picks what they need and then saves the file under a new name.
The problem is that when they open that file, they are still able to edit
the information within the drop-down box.
Is there a way to set this up so that the first time they use the template,
the drop down box is available BUT once they save their file, the cells with
the drop down box only shows the information they picked and the drop down
option is no longer available?
Thanks,
Jasper
certain options.
The user picks what they need and then saves the file under a new name.
The problem is that when they open that file, they are still able to edit
the information within the drop-down box.
Is there a way to set this up so that the first time they use the template,
the drop down box is available BUT once they save their file, the cells with
the drop down box only shows the information they picked and the drop down
option is no longer available?
Thanks,
Jasper