LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 to Excel 2003 (Split data to sheets) BCLivell Excel Discussion (Misc queries) 2 October 27th 06 07:17 PM
multiple sheets when importing into excel Nora Excel Worksheet Functions 1 January 30th 06 09:38 PM
hide sheets use data j2thea Excel Worksheet Functions 3 November 3rd 05 09:23 PM
automate creation of sheets in excel Daniel Excel Worksheet Functions 1 June 23rd 05 10:06 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"