Hi. I never work with VBA so I am struggling with what is a very easy problem.

Upon opening a workbook, I would like to be prompted with three options:

1) Go to sheet "A"
2) Go to sheet "B"
3) "No"; basically quit and stay in the tab I am currently in

I currently have a Yes/No routine, but now I have another tab that I have
to consider going to.

Appreciate any help.

hi
for the built in message box, no. it does have multiple options like "OK",
"YES""NO", "Abort""retry""Ignore". but these are not programable.
you would have better luck to create your own custom message box from a user
form using labels for the messages then put some code behind the labels to
"goto" the sheet selected.

regards
FSt1



"Scott A" wrote:

Hi. I never work with VBA so I am struggling with what is a very easy problem.

Upon opening a workbook, I would like to be prompted with three options:

1) Go to sheet "A"
2) Go to sheet "B"
3) "No"; basically quit and stay in the tab I am currently in

I currently have a Yes/No routine, but now I have another tab that I have
to consider going to.

Appreciate any help.