I would like to to ask if its possible to save a macro-enabled specific sheet from a workbook and to leave that saved file with only a specific module on my choice.
For example:
My original workbook will have for example 10 modules all containing lots of different VBA.
However, I want it to save a specific sheet through a sub, lets call that new sheet X-Sheet - a separate macro-enabled file.
At the same time this X-Sheet must have inside of it only one module on my choice.
I want that module to be accessible from anywhere so if I send/email this new one sheet macro-enabled Excell file to someone - they should be able to use subs and functions from there without them needing to have access to my workbook file with 10 modules. I mean they should have only the X-Sheet on the computer - not the original workbook for it to work.
I know this can be done manually but it would make it very repetitive as my project will require that to be done very often.
Summary:
I have 10 modules
I need to press a button (sub)
This sub will save a specific sheet from my workbook as a macro-enabled-excell-file
This separate file will have to have 9 of the original modules removed but to have 1 of the modules on my choice inside of it.
This would allow the end user to which I will send this file to be able to have the working buttons and functions but he won't have access to things that he/she should not see or alter (those 9 modules should be deleted from this new file).
Bookmarks