Jan 26 2022 11:14 PM
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 the required person. I have provided; add, edit & delete options too in the code. (this iam using as my phone book)
What i intend now is to get this phone book in any excel file which is open at that time. I have copied the code & the form to the PERSONAL.XLSB file. But i think the work sheet that contains the phone number details can not be manageable (that sheet i have copied to the xlsb file) in xlsb file. pls advice how it can be made workable? if no direct way, any tricky way/code available?
Thanks,
Hariprasadhari
Jan 27 2022 02:25 AM
Jan 27 2022 04:54 AM
Jan 27 2022 02:49 PM
Jan 27 2022 07:24 PM