Forum Discussion
Scrolling through hidden worksheets
"if there is another solution that does nor require me to enable macros"
The apparent answer is that a macro is required.
But you can execute a macro without "enabling macros" if the macro is contained in your Personal Macro Workbook — Personal.xlsb, in modern versions of Excel. Macros stored there are always enabled. And once created, this workbook an its macros are available to you (mostly hidden) every time you open your desktop version of Excel.
And the macro can use a user-defined form (UserForm) to receive your input and unhide the desired worksheet(s).
See the attached workbook for more information.
I'm facing the same problem. Up until a while ago, I was able to "filter" through hidden sheets by using first letter of a sheet in the Hidden Sheets Dialog Box.
Example: sheet names A_1, A_2, A_3 and so on. If I kept pressing "A", it would go from 1st to 2nd to 3rd sheet starting with the letter "A". Now, nothing happens anymore, it stops after finding the first match.
It was an easy job to find whatever hidden sheet I needed. Why is a macro required all of a sudden?
"Why is a macro required all of a sudden?"
I have no idea why. Like almost all of the Tech Community members, I am not a Microsoft employee, much less one who works on the Excel products.
Remember that you can let Microsoft know your feelings from within Excel—use the Feedback button under the Help menu.
