to write a macro that opens another worksheet when choose from drop down list

[tsogoo.n]

I need to write a macro that opens another worksheet when choose from drop down list

[jewelsharma]

Hi tsogoo.n,
Welcome to the forum.

What is meant by "opens another worksheet" here? It is the workbooks that open/close. Once a workbook is open - all its worksheets are already open; they may be active or inactive, hidden or visible; but they are always there. Please clarify your requirement!

Regards,
- Jewel