Protecting Formulae Without Password Protection of opening the Workbook

[Parkhurst]

Dear all,

I have a very simple spreadsheet which has cells that are formatted as protected to stop other from overwriting formulas, i have gone to protect worksheet on the tabs required and saved it.

This issue i have is that when someone tries to just open the workbook it asks for a password. I would like to allow anyone to open it without asking for a password whilst keeping the protected cells.

I hope you can help. Thanks in advance.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

[FDibbins]

If you dont password protect the file, anyone with a bit of excel knowledge can mess with your formulas

[XOR LX]

Hi,

Not sure I understand. Worksheet protection alone has nothing to do with the user being required to enter a password upon opening the file.

Regards