J
jamiee
Hi
I have a workbook which uses the activate/deactivate workbook events
to add an extra option to the excel right-click pop-up menu. I wish
the user to have this option available for all of the worksheets in
the workbook, and that they can rename the worksheets. I only want
this extra option available in this particular workbook.
Using the workbook activate deactive events works fine and
accomplishes this, however at times the extra option remains in the
right-click pop-up menu. When it has happened and the workbook is open
with another workbook, the other workbook can take advantage of the
extra option.
Does anyone know what could be causing this? I would of thought that
the activate/deactivate events would create a closed enviroment for
the pop-up menu, but there appears to be some flaws with it.
Thanks in advance.
I have a workbook which uses the activate/deactivate workbook events
to add an extra option to the excel right-click pop-up menu. I wish
the user to have this option available for all of the worksheets in
the workbook, and that they can rename the worksheets. I only want
this extra option available in this particular workbook.
Using the workbook activate deactive events works fine and
accomplishes this, however at times the extra option remains in the
right-click pop-up menu. When it has happened and the workbook is open
with another workbook, the other workbook can take advantage of the
extra option.
Does anyone know what could be causing this? I would of thought that
the activate/deactivate events would create a closed enviroment for
the pop-up menu, but there appears to be some flaws with it.
Thanks in advance.