I know how to copy and paste code from a module into a new book or export and import the .bas file. The problem is the people who will be using the new worksheet in a new book have no idea what a macro even is. Is there any code that can be written so when a person selects a tab to be moved, the macro code would go with it? They could copy the entire file and delete the tabs they don't need, but that seems like it would confuse them as well. The file is 24 mb anyway so no one really wants to copy it, they just want to move their tab which results from a drilled down pivot table.
Once again, thanks again for all the help.
k
Once again, thanks again for all the help.
k