What is the quickest way to copy all active and hidden sheets as well as modules to a new workbook and then prompt the user to save as?
What is the quickest way to copy all active and hidden sheets as well as modules to a new workbook and then prompt the user to save as?
some of the sheets are very hidden and must stay that way. Anybody?
CLOSE THREAD. found a better way to do it.
You might share your solution to help others!
The easiest way is to simly use saveas.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks