Hi everyone:
I'm trying to apply print settings and a few other format settings (row height, hide columns, etc) to only certain sheets in my workbook. However, when I run the code, it stays on the first tab (Summary tab) and applies the code but this is a sheet that I don't want to apply my settings to.
Please Login or Register to view this content.
Any help will be appreciated!
Last edited by egutierrez7; 03-23-2017 at 07:01 PM.
Try:
BTW: Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.Please Login or Register to view this content.
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, it also maintains VBA formatting.
Click on Edit to open your thread, 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
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you for the instructions on the Code rule.I updated it.
As far as your suggestion, it's still formatting that first sheet and doesn't move to the sheets I'm asking it to apply the formatting to. :\
I updated my code after the PageSetup End With and it seems to be working now. Apparently, my "ws.Activate" code was in the wrong spot. I appreciate your help!
Please Login or Register to view this content.
I tested this version and it worked:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks