The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My work

  • My badges

  • Twitter Updates

  • My Flickr Stream

    20140329-VMware-vSphere-Client-4.1-retry-with-compatibility-settings

    20140329-VMware-vSphere-Client-4.1-refuses-to-install-on-Windows-8.x-Requires-XP-SP2-and-up

    2014-03-06_0853-upright

    More Photos
  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,251 other followers

Microsoft Excel 2007/2010 – Protecting Workbooks and Worksheets

Posted by Jeroen Pluimers on 2012/05/04

One of the things about the Office 2007 and 2010 Ribbon is that it makes the things that you have remembered for 10+ years go into hard to find places.

My point is that according to the ribbon documenation:

A ribbon can replace both the traditional menu bar and toolbars.

Microsoft has decided to read the “a ribbon can replace” as “the ribbon replaces”. Thereby also introducing a whole new naming for the UI elements used in ribbons (see at the bottom).

Tab "Review"; Group "Changes"; Commands "Protect Sheet" / "Protect Workbook"

Tab "Review"; Group "Changes"; Commands "Protect Sheet" / "Protect Workbook"

Protecting a worksheet and workbook have been in the menu “Tools”, submenu “Protection” forever. But alas: No more “Tools” menu, and accompanying keyboard shortcut productivity (and I needed “unprotect workbook” because you cannot copy workbooks inside a protected workbook).

As “password protect worksheet” shows, it is now under:

  1. Tab: Review
  2. Group: Changes
  3. Commands: Protect Sheet / Unprotect Sheet / Protect Workbook / Unprotect Workbook

–jeroen

via: Microsoft Excel 2007 – Protecting Workbooks.

Naming of ribbon UI elements

Naming of ribbon UI elements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 1,251 other followers

%d bloggers like this: