View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bepenfriends Bepenfriends is offline
external usenet poster
 
Posts: 1
Default How to hide a macros/functions from excel sheets

Hi all,

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