There is a fair amount of "arm waiving" advise being dished out around here, and while some new members may be able to figure it out eventually on their own, we 'regular' contributors should do less of that and be more deliberate and focused with out contributions. No one's perfect, I do the shortcut answer too sometimes, but you got to try and assume anyone seeking help is not sure how to proceed.
>>>... It actually took me just under 2 minutes to complete the script for 201 tabs, I use excel to automate scripts regularly,...<<<
More arm-waving answers do no one any good.
OK I understand what you mean, but how far should you take it, as I suggested I tend to look at this as offering people a direction to look into, there are too many people on forums saying 'do this for me' who are incapable of doing anything without full blown tuorials on how to draw a yellow line, and tommorrow they come back and ask what if I need it to be red. The OP in this case picked up on the layout command and will use it as they see fit, with or without the script. Which I would say is a good result. And what you call 'arm waiving' I prefer to think of as dropping subtle hints to people who are genuinely looking to learn, ---Here is more arm waiving--- I could have posted a fully working excel spread sheet that would allow the OP to automate the process as I indicated, but that is how I would do the same job myself and is probably something the OP wouldn't even look at. And if anyone picks up on it and wishes the discussion to go in that direction then so be it.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register