ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   shared environment (https://www.excelbanter.com/excel-discussion-misc-queries/48629-shared-environment.html)

Alex

shared environment
 
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



Dave Peterson

I think you'll have to much more specific to get any useful response.

But I've used many workbooks that were marked readonly (to stop updates) and the
macros worked fine. So I don't think just having the workbook open in readonly
mode is enough to cause the problem.

Alex wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com