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

How about a list of workbook names each with their own hyperlink?

RSHF wrote:

Dave,
I am not trying to link sheets per say, I am really trying to enable the
user to be able to pull up different saved versions of the same sheet that
are stored in a seperate folder. I may not have made that very clear. Any
suggestions here?

"Dave Peterson" wrote:

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


--

Dave Peterson

Look at followhyperlink in VBA's help.

But why bother?

Just select a cell and Insert|Hyperlink and point at the file that should be
opened.

RSHF wrote:

How do I implement the hyperlinks within VBA

"Dave Peterson" wrote:

How about a list of workbook names each with their own hyperlink?

RSHF wrote:

Dave,
I am not trying to link sheets per say, I am really trying to enable the
user to be able to pull up different saved versions of the same sheet that
are stored in a seperate folder. I may not have made that very clear. Any
suggestions here?

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson