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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to consolidate 130 sheets into a summary sheet 6
Newbie for starters with excel, I am needing to transfer info fromsheet2 to the universe sheet. 1
More Rows/One Sheet vs More Sheets/Less Rows for best performance? 1
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
excel sheet name 2
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Show Only Fields Needed 0
sum 1

Back
Top