Forum Discussion
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 ...
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.
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.
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.
- Dear Doug Robbins,
Thanks for your quick response again.
I have shared the sample file to you now, kindly check & advice.
Thanks,
Hariprasadhari.