View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Can there be multiple passwords for one spreadsheet?

xl2002+ has this ability.

Tools|protection|allow users to edit ranges

Before xl2002, you could supply macros that only offer the user what you want
them to do.



Twin468 wrote:

I would like to have a level of passwords for the spreadsheet our company
works. Some users should have access to the whole sheet and some users would
be limited to certain cells.
Is this posible?


--

Dave Peterson