Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 05-24-2012, 12:32 AM
Dougiel Dougiel is offline Windows XP Office 2007
Join Date: May 2012
Posts: 1
Dougiel is on a distinguished road
Default Visibility of macros in PERSONAL.XLSB

I have about a dozen macros in PERSONAL.XLSB. If I enter a spreadsheet cell and click on the 'fx' button to insert a formula, then select 'User defined' as the category, all the macros in PERSONAL.XLSB are displayed. So far so good. However if I click on the 'Developer' tab in the ribbon, then click on 'Macros' only about four macros are displayed. I can see no difference in the definition of these macros from the others - why doesn't Excel show them all?

Update: OK, I think I see - to show on the Developer/Macro dialog, it must be a Sub with no arguments.
Reply With Quote

macros, personal.xlsb

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Placeholders visibility and ISO_IEC_29500-1_2011 standard Ilya Y PowerPoint 2 06-20-2012 05:32 AM
Short personal folders! martaa Outlook 1 01-31-2011 04:35 PM
Personal Folders transfer antonstef Outlook 1 07-13-2010 01:12 PM
sending personal letters misteroffice Word 3 12-23-2008 08:51 AM
Personal Folders first? kian1977 Outlook 0 09-25-2006 03:02 PM

All times are GMT -7. The time now is 02:54 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft