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

Worksheet

ResolvedVersion 2003

Fri 23 Jan 2009, 10:57 Delegate Priti said...

Priti has attended:
Excel Advanced course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course

Worksheet

Can you please let me know how I can password protect a worksheet on a workbook?
Is there a way in which each worksheet on a workbook can have a different password to open and edit?
Thank you

Tue 27 Jan 2009, 13:04 Trainer Amanda said...

RE: worksheet

Hello Priti

Thank you for your question.

To my knowledge, you can only have a password set up to open a workbook, not individual worksheets.

You can password protect each individual worksheet against having changes made, using Tools - Protection - Protect Sheet.

Kind regards
Amanda

Tue 3 Feb 2009: Automatically marked as resolved.

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Worksheet

Worksheet

RE: worksheet

Excel articles

Excel tip:

Select Single Data Marker