none
Workbook/worksheet events and adding names RRS feed

  • Question

  • Are there any events related to the use of named ranges? For example naming a cell or removing a name?

    The change event doesn't seem to get fired when I add a name (presumably because the name exists independently of the sheet, so strictly speaking nothing on the sheet has changed - it's just something else that has been created that refers to the sheet).

    Friday, August 1, 2014 2:49 PM

Answers

  • Are there any events related to the use of named ranges?

    No. Write this "dim withevents X as " but without the "" into the code module of a sheet.

    After you typed the last blank a drop down should appear with all objects that support events.

    If the drop down did not appear, click Tools\Options, in the Editor tab check "Auto List Members".

    Andreas.

    • Marked as answer by PatrickPS Monday, August 4, 2014 7:59 AM
    Friday, August 1, 2014 6:12 PM