Hi Bernie,

Sorry for the late reply, was moved to a different project, so could
complete. But i'm back and stil stuck.

I don't understand what to do, in regards to your last reply.
I'm not sure what some variable should be e.g:

If frmsysenq.Frame1.optAS400 = True Then SomeVariable = 1
SomeVariable should open the Tab i want? how would I code this?

Thanks


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=519689