Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 to Excel 2003 (Split data to sheets) | Excel Discussion (Misc queries) | |||
multiple sheets when importing into excel | Excel Worksheet Functions | |||
hide sheets use data | Excel Worksheet Functions | |||
automate creation of sheets in excel | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |