protection

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protection

Protection

resolvedResolved · Low Priority · Version 2003

Amanda has attended:
Excel Advanced course

Protection

hi, i want to protect my sales work sheet so that certain staff can not access the sales spreadsheet within a file?

RE: protection

Hi Amanda,

Thank you for your question.

Do you mean you would like to hide certain sheets in a workbook and then send the file to another person so they cannot see that hidden sheet?

If so, view the sheet and hide it via the Format Sheet and Hide command.

Then protect the workbook via Tools Protection and protect workbook. Set a password and save the file.

Test this out first just to make sure you are happy that this is exactly what you want.

I hope this answers your question.

Regards

Simon

Sun 22 Nov 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

View all Excel hints and tips


Server loaded in 0.09 secs.