That looks just about right. Could it be made to update on opening without asking permission? Otherwise, it looks just about perfect. Thanks again for all your help.
Quote:
Originally Posted by macropod
Hi ahrinn,
See attached. On opening the document, you'll get a prompt to allow macros to run. If you do so, you'll then get asked whether to update the random number. If you answer Yes, it'll be updated. To update the number afterwards, press Alt-F8, then click on 'UpdateRandomNumber', OK.
If that's what you want, I'll explain how to implement it.
|