blackie42
01-08-2009, 07:56 AM
Hi
I have a workbook template with modules/forms etc
I'd like to force the user to save the workbook using a different name
and then delete the code (modules & forms). This is to make sure the saved filesize isn't too big.
I've seen some code that uses VBIDE but am too much of a novice to understand and am confused as to how to use it in this context.
Any help appreciated
thanks
Jon
I have a workbook template with modules/forms etc
I'd like to force the user to save the workbook using a different name
and then delete the code (modules & forms). This is to make sure the saved filesize isn't too big.
I've seen some code that uses VBIDE but am too much of a novice to understand and am confused as to how to use it in this context.
Any help appreciated
thanks
Jon