Hello All,
currently I am working on getting a database setup with macros in VBA. I am facing the issue that when I upload my .xlsm to our teams sharepoint online. The built in macro button for opening a userform only works for me (who created it). If some of my teammembers try to press on the button they get the following error message: Run time error 76: Path not found. I know this has to do something with storing the document on Sharepoint online, but I couldnt find any thread that has the answer to this issue. Is there anything I can add to the code so everyone can open my macros that are built in the database?
I am very new to Excel VBA and coding so please do not judge.. :P
Many thanks to everyone trying to help me.
currently I am working on getting a database setup with macros in VBA. I am facing the issue that when I upload my .xlsm to our teams sharepoint online. The built in macro button for opening a userform only works for me (who created it). If some of my teammembers try to press on the button they get the following error message: Run time error 76: Path not found. I know this has to do something with storing the document on Sharepoint online, but I couldnt find any thread that has the answer to this issue. Is there anything I can add to the code so everyone can open my macros that are built in the database?
I am very new to Excel VBA and coding so please do not judge.. :P
Many thanks to everyone trying to help me.
