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.
I hope I made that clear. Thanks very much for any assistance that can be offerred.
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.
I hope I made that clear. Thanks very much for any assistance that can be offerred.