#1
|
|||
|
|||
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. |
Tags |
macros, personal.xlsb |
|
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 |