I am in need of help regarding Excel sheets and Vb.NET,
I am having a application which creates
some sheets on click of button
present in the main sheet. These operations are coded and kept in the
application directory as a excel file say "Base.Xls"
I use VB.NET to create the copy of this xls file when ever
user is creating
a input skelton for the work that to be done. This is just a file.saveas
method or workbook.saveas method.
Now I am including some buttons to do specific jobs in excel sheet. And the
macros/functions subroutine also in excel sheet using VB Script editor. Now
my question is
How can i hide the code which is used for those newly inserted buttons so
that the user will not see in the Vb Script editor and cannot change the same.
Please help me friends