Hi All!

I haven't played with VBA for quite a while now, so please excuse me if I am a little rusty!

What I would like to do is to open a named workbook and specific sheet with text from a cell reference.

I have two sets of radio buttons which give various text results when checked.

For ease of explanation set one returns small, medium and large whilst the second set returns red, green and blue

I have three workbooks (small, medium and large) each with three sheets (red, green and blue)

I would like to open one of three workbooks based on the output of the first set of buttons, i.e. small.xlsx, medium.xlsx or large.xlsx
and one of three sheets based on the output of the second set of buttons

I have used this piece of code to open the workbooks:

 

 Workbooks.Open Filename:=Worksheets("Sheet1").Range("cell with output from radio buttons").Value
This works fine, but I haven't been able to open a specific sheet within the workbook.

Any ideas?

Thank you for your help

Wiggy