View Single Post
 
Old 06-16-2024, 06:18 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
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

Greg
Without the DoEvents, on my machine the selection doesn't change so I think we can say there is variable behaviour with the selection.

Another alternative you might also add to the experiment list is to add the temp doc invisibly. Is it closing the temp doc that is the issue on your machine or changing the activedocument?
Code:
Set oDocTmp = Documents.Add(Visible:=False)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote