Forum Discussion

Hariprasadhari's avatar
Hariprasadhari
Copper Contributor
Jan 26, 2022

PERSONAL.XLSB

Hi,   I have a macro enabled excel workbook, in it one sheet contains name & phone numbers of my suppliers. i have put this sheet as hidden & using a custom made form i am getting phone numbers of ...
Macros and VBA
  • Hariprasadhari's avatar
    Hariprasadhari
    Copper Contributor
    Jan 27, 2022
    Dear Doug Robbins,

    Many thanks for your quick response.
    But still it is not working, see below my followed steps
    Saved my macro-enabled workbook (.xlsm) to .xlam file as you suggested.
    By default it saved to my ‘…\AppData\Roaming\Microsoft\AddIns’ folder
    Then i went to the developer tab, checked the add-in (the same file saved now)
    The macros is there, but can’t run. Getting error as below. The reason I believe is, the data saved in the worksheet is not visible in xlam file & the custom form can’t fetch the data from it. Pls advice if i missed anything.

    Run-time error '380'
    Could not set the RowSource property. Invalid property value

    Thanks,
    Hariprasadhari.
    • Doug_Robbins_Word_MVP's avatar
      Doug_Robbins_Word_MVP
      MVP
      Jan 27, 2022
      If you send a copy of the xlam file to me at dougrobbinsmvp[atsymbol]gmail[dot]com so that I can see exactly what you have, I will see if I can sort it out for you.
      • Hariprasadhari's avatar
        Hariprasadhari
        Copper Contributor
        Jan 27, 2022
        Dear Doug Robbins,

        Thanks for your quick response again.
        I have shared the sample file to you now, kindly check & advice.

        Thanks,
        Hariprasadhari.