Maybe you can steal some code from Debra Dalgleish's site:
http://www.contextures.com/xlToolbar01.html

RSHF wrote:

On my workbook I have a combo box which lists slightly different versions of
the same sheet (The master sheet). I am trying to enable users to scroll
through the check box on the master sheet and click the version they would
like to view, and that version of the master sheet would appear.

Summary:
1 Master Sheet
10 Different Versions of the same sheet saved as different files with
different amounts and type of data.
Sheets (The 10 ten different versions) listed 1-10, in the combo box.
The User would be able to scroll through the combo box and select the sheet
that they prefer.

Any assistance would be greatly appreciated!

--

Dave Peterson