Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Richard Buttrey; 08-22-2019 at 11:54 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Since this is your first post I'll add them but note for the future
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thank you so much! I will be sure to format it properly in the future
Can you explain exactly what you want to achieve, (by that I don't mean tell us what the code is doing but what your overall aim is), and why you think an Application Enable Events instruction is necessary?
That said this could almost certainly be simplified by starting the macro by making all sheets invisible (probably with a simple loop) then using the row number (5-54) and mapping that to a VBA sheet code name or sheet tab index number, and then making visible the relevant sheet.
Absolutely! In my workbook I have 45 or so sheets that I am using as questionnaire forms. My goal is that all of these forms (sheets) are invisible unless it is "requested". I wanted the sheets to be requested causing them to appear and no longer be invisible by inserting a #1 (is formatted to look like a checkmark) to the cell that is associated with that specific form. This way the only forms (sheets) that are visible are the forms that will need to be completed.
So Column B5 - B54 is where the #1 (formatted to look like a checkmark) would be entered. Column D5 - D54 are where my form names (sheets) are listed. So if B5 is marked needed (#1) than D5 the form become visible.Attachment 638375
Please upload the workbook so that we have something to work with. We need to understand the layout and VBA sheet code names.
It may hep if there is some common cell value to these sheets and the value is unique to only these sheets. That would make it much easier to hide all the sheets with a simple three line loop.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks