Hi, I need help with the following,
Scenario: I Require a command button to open a worksheet based on the text in a particular cell.
i.e. if cell b3 contains "apple", then open worksheet called "apple" only when the command button is clicked - (note cell b3 is a Data Validation box).
I have searched & tried to put together bits and pieces but to no avail...
Any help on this would be appreciated,
Cheers,
Scenario: I Require a command button to open a worksheet based on the text in a particular cell.
i.e. if cell b3 contains "apple", then open worksheet called "apple" only when the command button is clicked - (note cell b3 is a Data Validation box).
I have searched & tried to put together bits and pieces but to no avail...
Any help on this would be appreciated,
Cheers,