I've created an excel workbook with forms, reporting (lots of coding in VB).
If it's opened only on a one machine it's working well. But, if somebody
opens it read-only and does some reporting (that should be Ok for the
read-only mode), there is always a problem and odd data (empty reports, etc.)

Could I fix it somehow?

Thanks