How to protect entire workbook so it can be opened but not edited in any way

**Mike_in_Mass** · 10-17-2019, 11:28 PM

Good day all. I am designing a workbook for my guitar club in Excel 2003 to be used as a For Sale/Wanted hub for members to trade equipment.

I want visitors to be able to open the workbook, but not make any changes to the content.

I know how to protect the sheets, but I cannot figure out how to save the workbook so that some creep couldn't add a worksheet

and possibly embed some malicious content in it. I've tried the options in the "Save As" then "General Options" window with no luck.

Any help much appreciated.

Mike In Mass

**FDibbins** · 10-18-2019, 12:23 AM

Save it as read-only
It will still be "modifyable" but not savable

**Mike_in_Mass** · 10-18-2019, 09:05 AM

Thanks very much. Did the trick for me !

**FDibbins** · 10-19-2019, 01:05 AM

Happy to help and thanks for the feedback

How to protect entire workbook so it can be opened but not edited in any way

LinkBack

Thread Tools

Rate This Thread

Display

How to protect entire workbook so it can be opened but not edited in any way

Re: How to protect entire workbook so it can be opened but not edited in any way

Re: How to protect entire workbook so it can be opened but not edited in any way

Re: How to protect entire workbook so it can be opened but not edited in any way

Thread Information

Users Browsing this Thread

Similar Threads

Trying to change the time that I edited a workbook

What happens to a workbook that is edited after it is digitally signed?

Use a macro to extract cell data from opened workbook to new opened workbook

[SOLVED] copy entire sheet from closed workbook and insert into another workboook when opened

I need my macro to decect if a shared workbook is in use and cannot be edited and then do

Macro Help: Search entire workbook for user defined value, export entire row

[SOLVED] No entire view in edited shift dropdown list Nursing Schedule Exc

Bookmarks

Bookmarks

Posting Permissions