Protecting A Shared Workbook

  • Thread starter Melissa in New Orleans
  • Start date
M

Melissa in New Orleans

Hi
I would like to share a workbook, allowing input by some, but
I would like some only to view the information
How can I accomplish this
MS Excel 2003
 
D

Dave Peterson

Protect the workbook with a "password to modify".

File|SaveAs|Tools|General options|provide a password to modify.

And only share that password with the people who should update the workbook.
The others will be able to open the file in readonly mode.
 

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

Different rights to editing and for adding a text for online shared version of MS word 0
Outlook mail shared questions 0
Sharing Excel 365 Mac<->PC 0
Password protect new workbooks from template 0
Visio to Excel 0
Protecting Word 2019 document 0
Autonumber field in Excel that behaves the same as Access 0
Shared Workbooks & Code 1

Top