How to delete CommandButton and coding

[Sumeluar]

Greetings!

I have a template which uses a CommandButton to get my form copied, saved and printed and in turn automatically closes everything, It works just beautifull, Only problem is that the freshly copied sheet brings with it, the coding and the CommandButton and a few other lines that I don't want them to appear because other users are to have acces to it and mishandling is occuring in the sense of altering the form and it also looks ugly.

Is there an easy way to delete all the above before the new copy is made?

Regards!

Sumeluar

 

[venkat1926]

try this suggestison


From: Erik Dillenkofer - view profile
Date: Mon, Jul 28 1997 12:00 am
Email: Erik Dillenkofer <esd...@NOSPAMgate.net>
Groups: microsoft.public.excel.programming


> RE: xlVeryHidden modules

> A macro cannot VeryHide the module in which it resides. This is a feature of Excel, apparently designed for extra protection. If a macro calls a subroutine in another module, it will also be unable to hide that module.

> The only way to very hide all the modules in a workbook is to write a
> temporary module with the code:

> Sub HideModules()
> For each m in Modules
> If m.Name <> Activesheet.Name Then m.Visible = xlVeryHidden
> Next
> End Sub

> Make sure this module is the active sheet, then run the macro and delete it. Remember to protect your workbook, otherwise users can write their own macro to unhide all of yours.


reference:
http://groups.google.com/group/micr...lnk=st&q=hide+modules&rnum=1#2fcbb678df40a02e

 

[Sumeluar]

Thanks venkat1926, Looking forward to give it a try.

Regards!