Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 9th, 2006, 03:53 PM
Registered User
Join Date: Jan 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default cannot insert OLE command button event code

I dynamically added an OLE command button, and also its corresponding event code to an excel sheet. My VBA project is password protected. The code works fine if I log into my VBA project first. But for the users, they don't need to log into the VBA project, and they don't know the password either. The code cannot be run due to the protected status.

Is there a way I can work out this situation? How can I pretend to be the superuser in the VBA code to insert the event code?

Please advice. Thanks.
Old January 10th, 2006, 04:33 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 173
Thanks: 0
Thanked 3 Times in 3 Posts

You shouldn't see that behaviour otherwise no one would ever be able to distribute protected code.

I'm guessing that your users have theier macro security set to high (Tools -> Macro -> Security...) and it should be moderated down to medium or low depending on your attitude to macro risks.

If this is not the answer please could you post back with the exact description of error messages that are popping up etc. as this would make the problem a bit easier to diagnose.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button VB Code taraj Access 16 May 22nd, 2008 10:37 AM
MS Access help - VB Code for command button pari22 Access VBA 11 September 7th, 2007 11:13 AM
Command Button event WMV File C.W. Clark Excel VBA 2 August 7th, 2006 09:36 AM
enter key on textbox, performs button event code?? squeakstar Visual Basic 2005 Basics 4 June 22nd, 2006 05:13 AM
Call code behind from HTML button event X-Ken VS.NET 2002/2003 1 July 27th, 2004 12:46 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.