View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Shared Workbook - Best Practice

You could password protect each of the worksheets and not divulge the
password(s).

Or if you're on a network, place the file in a folder where the users have
read only access rights. They could retrieve the file and mangle it beyond
belief, but they could not overwrite the network copy.
--
Kevin Backmann


"Karin" wrote:

I would like to be able to have one person modify a workbook while many
people look at (but do not modify) the same workbook -- all viewing at the
same time.

What is the best method to do this? (It's important that the viewers not be
able to modify.)