Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

password protection

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protection

Password protection

ResolvedVersion 2007

Oliver has attended:
Excel Intermediate course

Password protection

How do I remove password protection from a workbook (contains only one worksheet).
Originally set up on Version 2003.

I want others to be able to amend any of the the contents.

Manty thanks

Oliver

RE: password protection

Hi Oliver,


Thank you for your question.

To remove password protection from an Excel 2007 workbook:

- Open the 'Review' tab on the Ribbon

- Select the 'Unprotect Sheet' button (towards the right of the Ribbon.)

- Enter password (if applicable)


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Regards,


Nafeesa

Microsoft Office Specialist Trainer

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

RE: Will be marked as resolved in 5 days

Hi Nafessa

'fraid your answer does not work.!

I hit the F1 key & tried that one and it WORKED!

Many thanks for your reply.

Regards

Oliver

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.