Password protection

Resolved · Medium Priority · Version 2007

Fri 7 Jan 2011, 11:00 Delegate Oliver said...

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

Mon 10 Jan 2011, 14:36 Trainer Nafeesa said...

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

Mon 10 Jan 2011, 14:37 Trainer Nafeesa said...

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.

Mon 10 Jan 2011, 15:14 Delegate Oliver said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips