The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hiding comments

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Hiding comments

Resolved · Low Priority · Version 2003

ReplyWed 2 Sep 2009, 09:28Delegate Liz said...

Hiding comments

Is it possible to hide comments in a password-protected document?

For upcoming training course dates see: Pricing & availability

ReplyWed 2 Sep 2009, 13:38Trainer Amanda said...

RE: Hiding comments

Hello Liz

Thank you for your question and welcome to the forum.

It appears that even when you apply protection to an Excel file, there are still ways of being able to see comments in the spreadsheet.

So I would suggest either making a copy of the spreadsheet and removing the comments and allow people to view this copy of the spreadsheet; or I think making a PDF of the spreadsheet would stop people being able to view the comments.

Kind regards
Amanda

ReplyWed 9 Sep 2009, 14:05Delegate Liz said...

RE: Hiding comments

Thank you

Wed 9 Sep 2009: Automatically marked as resolved.

Excel articles

· Data Validation In Excel: Not As Daunting As It Sounds
· How To Convert Text To Columns In Excel
· The Mysteries Of Excel Explained
· Discover The PMT, IPMT And PPMT Functions In Excel
· Conditional Formatting in Excel 2007

Please browse our web site to find out more about
excel computer training london and other Microsoft training courses.

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

Hi,

Please help with animation.

6 photo spaces (many photo images) on left side of page.
5 bullet points on right side of page.

I would like to click through each bullet point while the photos continuously fade in and out independently of the bu..