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

protection

ResolvedVersion 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.

Excel tip:

Jumping Across the Excel Screen

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Alt+PgDn and Alt+PgUp is the equivalent across the spreadsheet.

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.1 secs.