I have an excel file which has more than 100 rows for each student in my class. Each row has the current points of a certain student and is named with his firstname_lastname. I wonder how I can put online and allow every student to only access his row using a passcode or something. Any ideas please?

  • Excel isn't the best tool for that. You can solve it with VBA, but it's rather complicated and it's very easy to break password protection of VBA modules. What other tools do you have access to? I think best solution would be if you can upload that to a sharepoint site where you can grant access at record (row) level. Other workaround can be mail merge in Word where you can generate (and even send in e-mail) documents at student level. – Máté Juhász Oct 15 '15 at 7:26
  • @MátéJuhász could you please show me how this can be done on sharepoint? – Tak Oct 15 '15 at 21:28
  • It's called audience targeting in sharepoint, you can find more information on it here (support.office.com/en-in/article/…) and here (technet.microsoft.com/en-us/library/…), and also a lot of information is available online – Máté Juhász Nov 6 '15 at 15:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.