noisepoet
Board Regular
- Joined
- Oct 19, 2006
- Messages
- 82
I have created a calendar user form in VBA that will enter a selected date into a cell. I've added this to the right mouse click shortcut menu with some success, but not complete success. Here's the problem:
Each time I restart Excel, the shortcut menu displays an additional added function. Meaning, the first time I added the calendar to the shortcut menu, it was listed on the menu once. But when I exited out of Excel and started it up again, the shortcut menu displayed two of the new function. In my attempts to fix this, I now have eight calendar functions added to my shortcut menu. Additionally, only the most recently added one works properly. The previous added functions provide an error message stating that the macro cannot be found.
Can you help me with this?
Each time I restart Excel, the shortcut menu displays an additional added function. Meaning, the first time I added the calendar to the shortcut menu, it was listed on the menu once. But when I exited out of Excel and started it up again, the shortcut menu displayed two of the new function. In my attempts to fix this, I now have eight calendar functions added to my shortcut menu. Additionally, only the most recently added one works properly. The previous added functions provide an error message stating that the macro cannot be found.
Can you help me with this?