The title's a mouthful, but the problem's more common than you might think. Let's suppose you inherit a document with a footer that contains left and right aligned text. All is well until you change the right margin and the right-aligned text fails to align properly to the new margin. Why might that happen and how would you fix it?Last week we asked…
Why won't my Forms option buttons work? Gbently got it right with "You left the linked cell protected." A Forms control links to a cell, which stores the control's value or state. In the case of options buttons corralled in a group box, the linked cell would store the value of the selected option button—1, 2, 3, and so on. If you protect the sheet, without unlocking the linked cell first, Excel can't update the linked cell when users click an option button.
It's a mistake of omission and easy to fix. Simply unprotect the sheet, unlock the linked cell, re-protect the sheet, and save it. Doing so has one unfortunate side effect as users will be able to select the linked cell. Most likely, you won't want that. How do you allow users access to valid input cells (unlocked cells) without also allowing access to the linked cell?
TechRepublic's Microsoft Office Suite newsletter, delivered every Wednesday, is designed to help your users get the most from Word, Excel, and Access. Automatically sign up today!
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.