I have a question about using the Prompt Values column in the workbooks.

This is admittedly a little weird, and situationally specific. We're trying to set up some controls on our locks where we can choose either keyed alike or not in our wizard. With keyed alike activated, you can select one lock key code and all lock cylinder hardware will be that key code. If keyed alike is not selected, we have a formula that goes to the look up table with the lock codes, and selects a random index. Nothing wrong with how that functions. Where we're stumped is, even if the whole job isn't keyed alike, we want all locks in an individual cabinet to be.

The problem is that with the randomizing being done by a formula, every time a workbook is reloaded, the formula runs, giving a different code. So, what we've been attempting to figure out, if it's possible, is how to get the formula to run once to get the random value, then pass that value and not the formula, locking it in.

Our best effort so far has been to put the randomizing formula in a L! product prompt for the lock code, and the pass that to the Prompt Value column for the subassembly. The reasoning being that all subs would receive the same value, not the formula, and therefore all locks in that cab would have the same key code. Since, when you look at the prompt you passed the value to in the sub, it's "hardcoded" for all intents and purposes inside the sub.

It doesn't work. When looking at the Prompt Values column in the subassembly tab, all the values are the same. When you open the individual subs and look at the prompt, they're all different. I'm guessing the formula re-runs as it loads each sub, thwarting our efforts. Anyone know how to get a formula to not re-evaluate, or have an idea how to get this to work?