View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default cells protection

I knew about the sheet tabs colors and the ability to work with protection
applied to specific users. But I didn't realize you could assign separate
passwords to each range. Guess I will have to install it on the main
computer or walk downstairs and play with it.

--
Regards,
Tom Ogilvy


Dave Peterson wrote in message
...
And colored worksheet tabs, too!

Tom Ogilvy wrote:

It added the ability to assign separate passwords to each range.

Wow!

--
Regards,
Tom Ogilvy

Dave Peterson wrote in message
...
xl2002 added that feature.

Tools|Protection|Allow Users to Edit Ranges

"gulp!" wrote:

Hello,
is it possible to protect different cells group of a sheet
with different password so that different users can have
possibility to modify only some cells and not others?

Thanks

--

Dave Peterson


--

Dave Peterson