Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Excel Protection

Excel Protection

Excel Protection

I have an question relating to Excel protection. I know that I can set a password to OPEN and a separate password to EDIT. However is there a way to prevent recipients from opening as read only (they will have been provided with the password to open only) and then saving locally as a separate new spreadsheet without any password at all?

The Excel file is distributed to recipients by email for their information and although they should not really need to amend or edit in any way, it would be safer - with reference to new data protection legislation - for copying to be barred.

Any help would be appreciated.

Thanks in advance

RE: Excel Protection

If you like to disable editing, use rather worksheet/workbook protection:
1) worksheet protection:
Right-click sheet's tab and select "protect". You can protect with various schemas, including selection of cells (options for users in the list in the dialog). Before applying protection it is possible to individually set cells behaviour in protected worksheet ("protection" tab, the last in big formatting dialog for ranges): no protect and hide formulas for protected cells,
2) workbook structure prodection:
Via "file" tab on ribbon), disables adding/removing sheets to workbook.

Note that protection for xlsx or xlsm workbook, that can be opened, is wery, wery weak, worse than in previous format.


RE: Excel Protection

Thanks combo
I do remember way back using the worksheet protection before ... but that was a long time ago.
This has been a very helpful reminder - appreciated
I think for what I want to achieve this will work very well
Thanks again


RE: Excel Protection

That may not be what you want, but - you can do: Save As... PDF smile

---- Andy

There is a great need for a sarcasm font.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close