People are entering information into specific parts of the workbook too.
Nothing data-intensive, but perhaps updating a cell with +$250,000, or
-$90,000, or whatever, and adding comments too. There are probably
alternatives to the method that I'm employing now, but I think it is probably
pretty efficient as it is right now. Querying Access is an option, but I
thought this would just be a short-term solution, which would become obsolete
as some new technologies are rolled out, but roll-outs are always postponed
and very buggy when deployed, so we came up with this interim solution.

Any others have any experience with Excel's 'Shared' feature?

Thanks,
Ryan--

--
RyGuy


"JP" wrote:

I understand your problem, but I still don't see why the workbook
needs to be shared, if all they are doing is looking at the worksheet.

What do you mean by "logging on" and how do you tell who is who?

If the data is that sensitive, why not break it out into separate
workbooks? Maybe a re-think of the design is in order. Or store the
data in an Access table, and write some Excel code to conditionally
query the mdb for the necessary data, depending on the requestor?

--JP


On Oct 23, 12:35 pm, ryguy7272
wrote:
Thanks for the comment JP. Yes, it has to be shared, as a couple dozen
people are logging in to the workbook to check the status of some sales
stuff. Yes, we need the macros to control which sheets are displayed when
each user logs in (well, when it works correctly...). I think this project
would have been much better suited for Access, but virtually no one here has
Access on their computers, except me, and virtually no one here knows how to
use Access, except me.

Any other comments, suggestions, etc.

Thanks,
Ryan--

--
RyGuy