VBA assistance

Joined
Jan 2, 2014
Messages
5
Reaction score
0
Good morning, and a Happy New Year to everyone.

I would be very grateful if someone could help me with the following head scratcher. :)

Goal: write a macro to open the most recently added worksheet in a workbook.(Excel 2007)

Background: As part of a macro, periodically (perhaps twice a month, but it can be more) a new worksheet is added to the workbook, (copied from an existing worksheet), linked to other existing worksheets, re-named to the current date, and then hidden.

Question: Is there any way that the user can click on a button to launch a macro that will unhide the most recent of these newly added sheets?

It's been perplexing me for a couple of weeks now.:confused:

I hope I made that clear. Thanks very much for any assistance that can be offerred.
 

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

Top