ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Protecting A Shared Workbook (https://www.excelbanter.com/setting-up-configuration-excel/113673-protecting-shared-workbook.html)

Melissa in New Orleans

Protecting A Shared Workbook
 
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
--
Thank you so much
Melissa in New Orleans

Dave Peterson

Protecting A Shared Workbook
 
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.

Melissa in New Orleans wrote:

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
--
Thank you so much
Melissa in New Orleans


--

Dave Peterson


All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com