Using forms to navigate

M

mdavisfl

I have multiple Workbooks with multiple Worksheets and Charts in each. Right
now I have a central worksheet with a bunch of Command Buttons with Macros
that navigate around these sheets and charts.

I want to develop a Form (?) to navigate to Workbook1>Sheet1,
Workbook2>Chart3, etc. For example, choose Workbook 1, then get the
sheet/chart choices within that Workbook. I would like to return to this
central location when the requested sheet/chart is closed.

What is the best way to develop a form that navigates like this and also
allows you to return to the central location?

Thank you for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
To copy Data from a row in one wrokbook and insert in a sheet of another workbook 0
Combining sheets into one file 0
Can I Move replace instead of Move copy 2
HELP!!! 1
Hyperlink to another Workbook (97) 1
VBA Macro Training in Chennai 0
Look up across multiple sheets 1

Top