I am looking for advice on how to resolve the following issue.
As part of a volunteering project I have automated an Excel spreadsheet using VBA. I have written a lot of code that includes user forms and classes.
I would like to allow other volunteer to access the spreadsheet and make some changes to the content (just the content, not the VBA code). Their editing may have to be done through VBA user forms.
The easiest way to allow this is to install a remote control software (like Team Viewer) and distribute the access codes to the volunteers. Unfortunately this would not be the optimal solution for security and continuity reasons.
Does anyone know a better way to allow users to edit a spreadsheet from remote that does not cost a fortune?