comments

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

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

Comments

resolvedResolved · Low Priority · Version 2003

Rosie has attended:
Excel Intermediate course

Comments

How do you hide a comment on a password protected excel spreadsheet?

RE: Comments

Hello Rosie

Thank you for your question and welcome to the forum.

It appear that applying protection cannot stop someone from being able to view comments in a spreadsheet, even if you choose not to display them.

I would suggest either:
1. Making a copy of the workbook and deleting the comments so that you can provide a copy of the file without the comments; or

2. Create a PDF of the spreadsheet.

Kind regards
Amanda

Fri 11 Sep 2009: Automatically marked as resolved.


 

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips


Server loaded in 0.08 secs.