Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-30-2012, 06:45 AM
ahrinn ahrinn is offline Random number difficulties Windows XP Random number difficulties Office 2007
Novice
Random number difficulties
 
Join Date: Jul 2012
Posts: 7
ahrinn is on a distinguished road
Default

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 View Post
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.
Reply With Quote
  #2  
Old 07-30-2012, 06:57 AM
ahrinn ahrinn is offline Random number difficulties Windows XP Random number difficulties Office 2007
Novice
Random number difficulties
 
Join Date: Jul 2012
Posts: 7
ahrinn is on a distinguished road
Default

I do notice that it seems to pull numbers from a set list. Every time I open it and agree to update the number, I get the same number. If I tell it to update when already open, it seems to come up with the same numbers in the same order. Is there a way to get around this? Out of curiosity, if I told it to print 100 copies of the document, would there be a way to get a different number on each document, or would it print 100 copies with exactly the same number? If I'm asking for the impossible, please let me know. Thanks again for all your help and knowledge.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
random pop up wont go away 464646 OneNote 0 05-01-2012 04:34 AM
how can i make random variant neezeen Word 0 11-22-2011 08:08 AM
Random number generator for Powerpoint 2011 kala85 PowerPoint 0 11-19-2011 06:16 AM
Random number difficulties Visio random crash? maxoys45 Visio 5 10-25-2010 09:15 AM
Random number difficulties Random names from a given list professor snape Excel 1 06-06-2009 09:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft