Hi
I recently used some code kindly supplied 8 years ago (!) by Tom Urtis
http://www.mrexcel.com/forum/excel-questions/321894-userform-select-worksheet.html
and it works brilliantly for my purposes - BUT only on my machine + my session/profile.
On other machines or on my machine with someone else's login it fails here:
The message I'm getting is that objOpt is not defined.
I know this is a really specific issue - so I'm kinda hoping Tom will see this and have some idea what gives
But if there's anyone else that has any ideas why I'm blessed to have this working and not my poor colleagues please jump in.
Cheers
Zoe
I recently used some code kindly supplied 8 years ago (!) by Tom Urtis
http://www.mrexcel.com/forum/excel-questions/321894-userform-select-worksheet.html
and it works brilliantly for my purposes - BUT only on my machine + my session/profile.
On other machines or on my machine with someone else's login it fails here:
Code:
If .Show = True Then
For Each objOpt In wsDlg.OptionButtons
If objOpt.Value = xlOn Then
optCaption = objOpt.Caption
Exit For
End If
Next objOpt
End If
The message I'm getting is that objOpt is not defined.
I know this is a really specific issue - so I'm kinda hoping Tom will see this and have some idea what gives

But if there's anyone else that has any ideas why I'm blessed to have this working and not my poor colleagues please jump in.
Cheers
Zoe