PC Review


Reply
Thread Tools Rate Thread

add an event procedure and hide the code

 
 
John Smith
Guest
Posts: n/a
 
      6th Dec 2006
I have a vb macro that adds a workbook and adds code to
worksheet_selectionchange procedure. The problem is the code added
is available for everybody to see. I would like to hide the code
so no one can see it. Is it possible to do so?

I read somewhere that says even if the worksheet's VBProject is
programmatically protected, the protection only takes effect after
the sheet is saved. In other words, before the sheet is saved,
everyone can see the code. Not sure if this is true. I haven't
been successful in programmatically protecting a VBProject.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Event Procedure] Code Behind Form Howard Microsoft Access Form Coding 3 30th Mar 2008 06:50 PM
I need the code for event procedure of text box BobC Microsoft Access Forms 11 22nd Mar 2008 11:42 PM
Event Procedure - Extending code =?Utf-8?B?VEJE?= Microsoft Excel Programming 2 29th Sep 2005 03:16 PM
Inserting an event procedure into sheet code roybrew@att.net Microsoft Excel Discussion 0 20th May 2005 09:03 PM
Event Procedure Code Nick Microsoft Access Form Coding 2 21st Jan 2004 10:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:40 PM.