On Mon, 23 Jan 2006 21:08:55 GMT, MGFoster <me@privacy.com> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Did you spell CommandBar correctly (there are 2 m's)?
Do you have a Reference to Microsoft Office 11.0 Object library? This
is in the VBA window, menu item Tools > References... . The CommandBar
is an item in the Office Object library. It may not be installed on the
other computers.
Actually, all these were OK. I figured it out. Like a moron, I
decided to remove the Startup form reference to the App main menu. I
THOUGHT I could do this because my code already enables and shows the
menu during the close event of the title form. Apparently, if the
main menu is not referenced in the startup form, the command bar
object code cannot find it. That makes no sense to me but after I
replaced the missing Startup form "Default Menu" entry with the name
of the App main menu, the whole thing worked right again. Go figure!