View Single Post
 
Old 07-24-2016, 07:15 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The randomiser works for me but I changed it slightly to test.
Code:
    lngIndex = Int((16) * Rnd)
     MsgBox lngIndex & vbCr & strQuotes(lngIndex)
It wouldn't work if you had your code in a template because it needs a saved document path which you don't have when opening a new document. It also presupposes that that your document contains the tbRandomQuote object.

Could your issue be due to the timing of the AutoOpen macro actually running prior to the opening document becoming the 'ActiveDocument'?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote