ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   customized menu is empty (https://www.excelbanter.com/excel-programming/323932-customized-menu-empty.html)

john macdonald

customized menu is empty
 
I have sent a workbook to a colleague. My customized menu appears but the
associated commands are not there. I have tried all the conventional 'help'
remedies. The menu items are associated with macros. Changing the security
settings does not help. Both machines are running under Windows XP and have
Office XP loaded.

I would be grateful if someone could point me in the right direction

gocush[_29_]

customized menu is empty
 
If you open your collegues VBE are the macros there? If not you have not
sent the macros with the wbk.
If they are there, are the menu items assigned to those macros or are they
still looking for the macros in YOUR wbk (perhaps named something different
or on a different drive or folder)?

"john macdonald" wrote:

I have sent a workbook to a colleague. My customized menu appears but the
associated commands are not there. I have tried all the conventional 'help'
remedies. The menu items are associated with macros. Changing the security
settings does not help. Both machines are running under Windows XP and have
Office XP loaded.

I would be grateful if someone could point me in the right direction


john macdonald

customized menu is empty
 
Thanks for your help. At first look the macros are looking in the wrong
place. I'll confirm once I've redone the links. Thanks again for your quick
response.

regards

john macdonald

"gocush" wrote:

If you open your collegues VBE are the macros there? If not you have not
sent the macros with the wbk.
If they are there, are the menu items assigned to those macros or are they
still looking for the macros in YOUR wbk (perhaps named something different
or on a different drive or folder)?

"john macdonald" wrote:

I have sent a workbook to a colleague. My customized menu appears but the
associated commands are not there. I have tried all the conventional 'help'
remedies. The menu items are associated with macros. Changing the security
settings does not help. Both machines are running under Windows XP and have
Office XP loaded.

I would be grateful if someone could point me in the right direction



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com