Windows authentication per sheet

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

My shared Excel file is on the network and has multiple sheets.

I want all sheets to be readable by all ... and each sheet writeable by the
"sheet owner".

So I (as the administrator) would designate an owner to each sheet, and each
sheet can only be written to by its owner, using (ideally) Windows
authentication.

Is this at all possible??
 
Hi
you could create some code in VBA which does this. But this kind of
protection is easily circumvented then the user just disables macros.
IMHO Excel is just not designed for such a type of application.
 
Back
Top