Hello,
I have prepared a excel file with a variety of different sheets as databases and userforms that populate those databases. I was wondering what the best way to share access to the userforms would be so that multiple people could access the userform GUI but not the excel databases behind the userform. I looked into Excel Online but it seems that the macros I created were not available on it. Ideally I would like to eventually have the userforms run on some tablets so the data entry could be done remotely.
I have prepared a excel file with a variety of different sheets as databases and userforms that populate those databases. I was wondering what the best way to share access to the userforms would be so that multiple people could access the userform GUI but not the excel databases behind the userform. I looked into Excel Online but it seems that the macros I created were not available on it. Ideally I would like to eventually have the userforms run on some tablets so the data entry could be done remotely.