First, I'm new to Office 2007
Second, I'd like to add macro buttons to the quick access toolbar that are associated with a certain worksheet. That is they should be available only when the worksheet is active.
  • I open the Quick Access Toolbar and select "Macros" in the "Choose Commands From" - I can see the macros I want to include preceded by the 'ProgramName!...' prefix. Note: there are several others that are in ProgramName, but do not have this prefix
  • If I select "For ProgramName:" from the "Customize Quick Access Toolbar" drop-down, all these prefixed macro names disappear, but the non-prefixed ones stay.
  • Both sets of macro are only in the ProgramName file. They are all public Subs with no arguments.
So, what causes the difference? Why can't I see all my macros? Thanks and a tip 'o the hat,

Mark