[AccessD] DoCmd.OpenModule for Access - Something similar for Excel ?

How about:

Right click on the ribbon and select Customize the Ribbon
Select All Commands in the left hand combo
Click on Home in the right hand list
Right click and select Add New Group
Click on the new group
Locate View Code in the left hand list and add it to the new group.

As an alternative to the New Group on the Home screen, you could Select "Add New Tab" 
and put the button in ther group on that new tab.

-- 
Stuart


On 19 Sep 2014 at 2:11, Brad Marks wrote:

> Darryl,
> 
> I would like to push a button to open up the VBE and see the code in a
> module.
> 
> Thanks,
> Brad
> ________________________________________
> From: accessd-bounces at databaseadvisors.com
> <accessd-bounces at databaseadvisors.com> on behalf of Darryl Collins
> <darryl at whittleconsulting.com.au> Sent: Thursday, September 18, 2014
> 7:58 PM To: Access Developers discussion and problem solving Subject:
> Re: [AccessD] DoCmd.OpenModule for Access - Something similar for
> Excel        ?
> 
> Hi Brad,
> 
> I work mostly with Excel -  When you say "set up buttons in Excel in
> order to open modules" - you mean to press a button in the workbook to
> open up the VBE so you can see the code in that module, or do you mean
> to assign code to run when the button is pressed?
> 
> As you have noticed.  There are gobs of little syntax issues between
> Access VBA and Excel VBA.
> 
> For all things Excel - you can also try the Excel-L (or Excel G)
> lists.  They are very responsive and help.  Been subbed for years on
> both (decades actually).
> 
> G is usually for basic questions (How do I apply a Conditional Format
> - that sort of thing) L is for more prickly advanced issues and code
> stuff
> 
> Naturally there is a wide grey area in that sort of classification. 
> Many folks are subbed to both so only post to one or the other.
> X-posting is not necessary or appreciated.
> 
> The EXCEL-L list is hosted on L-Soft international's LISTSERV(R)
> software running on Microsoft Windows Server 2008 R2. For
> subscription/signoff info and archives, see
> http://peach.ease.lsoft.com/archives/excel-l.html .
> 
> Cheers
> Darryl
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Friday, 19 September 2014 6:46 AM To: Access Developers
> discussion and problem solving Subject: [AccessD] DoCmd.OpenModule for
> Access - Something similar for Excel ?
> 
> All,
> 
> I really like the DoCmd.OpenModule when developing in Access.
> 
> Recently I have started a large project that is going to be using
> Excel.  I have very little experience with Excel VBA.
> 
> It appears that DoCmd.OpenModule will not work with Excel VBA.  Is
> there another way to set up buttons in Excel in order to open modules?
> 
> I know that this is really an Excel question and not an Access
> question, but I thought that someone in this group may have run into
> this before.
> 
> Thanks,
> Brad
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>