Cell content into VBA code

[CHSLax60]

Is it possible to put the content of a cell dynamically into the VB code. Here is what I'm trying to do:

Workbook 1 contains a cell with the name "Workbook 2" in it. I want to have a button that can open Workbook 2 based on the content of that cell. That way if I change the content of that cell from "Workbook 2" to "Workbook 3" than when I hit the button Workbook 3 would open instead of Workbook 2.

 

[Scott Huish]

Workbooks.Open Range("A1")

 

[CHSLax60]

Workbooks.Open Range("A1")

I quess when you're new, you focus so much on the hurdles you have trouble getting over, that you don't pay attention to the untied shoelace that ends up putting you on your face and makes you look the dumbest.

Thanks from the short bus.