CommandBarControl object
I want to embed a custom menu in an old (working) spreadsheet.
I have downloaded a number of pre-written solutons which all work when used
in the original spreadsheet downloaded. However, when I cut and paste the
code into my spreadsheet I get the compiler error "User-defined type not
defined" on the statement _dim xxx as CommandBarControl_.
WHY?
If it works on its own, why won't it work in my spreadsheet?
I have been struggling with this for too many hours now so any help will be
greatly appreciated.
Thanks,
Fred
|