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![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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