Edit: *** I title the post incorrectly*** I want to Save Hidden Worksheets Only
I am trying to save individual worksheets using the tab names. I have the code to save them as I want, but it saves all the worksheets, when I just want the hidden sheets.
I have attached a sample file. Here's the code I am using so far. Thanks very much, I appreciate the help!!!
Please Login or Register to view this content.
Last edited by Hood; 08-27-2017 at 08:30 AM.
Here you go, this saves 4 files as per example file.
Please Login or Register to view this content.
Last edited by bakerman2; 08-27-2017 at 08:36 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Perfect Thanks!
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks