reset shortcut menu

[eHanSolo]

hi all,

i've just written a macro and assigned it to an item to my (right click) shortcut menu. it works really well.

problem is, how do i initialize it when i open that specific workbook and how do i remove it when i close that workbook?

any ideas would be cool.
thanks!"!!!


e

 

[CautionMP]

Create the shortcut to the Open event for the workbook ([tt]ThisWorkbook, Workbook_Open()[/tt]) and remove it in the BeforeClose event ([tt]ThisWorkbook, WorkBook_BeforeClose()[/tt]).

Hope this helps,
CMP

Instant programmer, just add coffee.

 

[eHanSolo]

certainly has helped! thanks CMP