Hello
I have a complex workbook that is a Material Log book for students in cabinetmaking class. Each student has a password that gives them access to their own sheet . There are lots of macros in this workbook. along with lists, and linked cells for calculating prices of materials used.
I would like to try to house the workbook online so student can access it from their phones or individual computers both on and off campus. I tried Sharepoint/Office 365 but when I create a link from the file stored on my Sharepoint drive the file opens with macros disabled.
Anyway cost effective way to put this out there allowing students to access the file with Macros so they only have access to their sheet?
We are in a K12 school so I do not have a ton of resources to spend on this project.
Thanks Mike
I have a complex workbook that is a Material Log book for students in cabinetmaking class. Each student has a password that gives them access to their own sheet . There are lots of macros in this workbook. along with lists, and linked cells for calculating prices of materials used.
I would like to try to house the workbook online so student can access it from their phones or individual computers both on and off campus. I tried Sharepoint/Office 365 but when I create a link from the file stored on my Sharepoint drive the file opens with macros disabled.
Anyway cost effective way to put this out there allowing students to access the file with Macros so they only have access to their sheet?
We are in a K12 school so I do not have a ton of resources to spend on this project.
Thanks Mike