LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
WCM WCM is offline
external usenet poster
 
Posts: 59
Default Option Private Module (for Object Modules)

Hi Friends,

In my Excel Project, I have hidden all VBA code modules by inserting 'Option
Private Module' in the General Declarations section; I have also password
protected the VBA project.

Question:
I have a command button on one worksheet - the button has VBA code behind it
(simple code that calls a sub proc from a code module).

I would like to hide the code behind the button, but there seems to be no
way to hide code that is in an Object Module (as opposed to a standard Code
Module).

Any way to hide code that is behind a command button so user cannot go into
VB design mode and see that code behind the button? Note: Assume that
protecting the worksheet is not an option.

Thanks in advance ...

Bill
 
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
Option Private Module Smallweed Excel Programming 3 June 24th 08 02:38 PM
Improve method of calling a private function in a private module XP Excel Programming 1 April 30th 08 06:41 PM
Option Private Module RB Smissaert Excel Programming 5 April 4th 06 04:53 PM
Public, Private, Event modules, Forms modules,,, Jim May Excel Programming 11 October 31st 05 03:12 AM
Option Private Module not preventing cross project referencing seisman Excel Programming 2 July 29th 05 03:24 PM


All times are GMT +1. The time now is 01:33 AM.

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"