LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default add an event procedure and hide the code

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.
 
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
Event Procedure doesn't run pat59 Excel Programming 3 July 19th 06 04:00 PM
Event Procedure - Extending code TBD Excel Programming 2 September 29th 05 03:16 PM
How to trap delete row event and hide column event? Alan Excel Programming 3 April 26th 05 04:25 PM
OnTime event not firing in Workbook_Open event procedure GingerTommy Excel Programming 0 September 24th 03 03:18 PM


All times are GMT +1. The time now is 06:15 PM.

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

About Us

"It's about Microsoft Excel"