I need to use VBE to copy a worksheet from an existing workbook into a new one. The original worksheet has a private function used for data validation which I don't want in the new workbook.
I'd prefer not to modify the VBProject object directly as it'll be running under XP and used on several different computers by users who shouldn't be let anywhere near the security settings, and these won't be set to allow VBE to modify VBProject components.
Is there an easy way around this?
Thanks,
Steve
I'd prefer not to modify the VBProject object directly as it'll be running under XP and used on several different computers by users who shouldn't be let anywhere near the security settings, and these won't be set to allow VBE to modify VBProject components.
Is there an easy way around this?
Thanks,
Steve