Access User Defined Function in all workbooks Excel

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

Комментарии • 7

  • @ashoksahu9546
    @ashoksahu9546 5 лет назад

    Very nice video.

  • @mouadmad55
    @mouadmad55 2 года назад

    Thanks for the tip.

  • @zoltanmeszaros7060
    @zoltanmeszaros7060 3 года назад

    Hi Barb, thank you, it was really helpful. Just one question. If I open a new excel sheet, the references disappear, and I have to use the function with the longer frame. (start with personal.xlsb). Do you have any ideas, how can I keep the linkage and short form of the function across the sheets?

    • @BarbHendersonconsulting
      @BarbHendersonconsulting  3 года назад +1

      Unfortunately there is no easy way that I know off

    • @mansoorp7115
      @mansoorp7115 2 года назад

      try to create excel addin for the same function, it should work

  • @rickkeev4919
    @rickkeev4919 5 лет назад

    I create my (simple function type) in the autocorrect dictionary by using relative references in the formulas.