Rnd function used in VB on network
 

I'm using RND and Randonize statements in VB appications
in Excel workbook. It works on my system but if any other
use access this file on my c: drive it doesn't reset the
randon sequence. So every time they open the workbook it
generates the same randon numbers. I am using the Ranonize
statement with on number option.