Learn the solution to last week's Excel challenge and test your skills with this week's Outlook 2007 challenge.
- Tgullo suggested using the Data Validation feature, setting the whole sheet to accept nothing and then resetting the input range to accept anything. It's quick and it works great.
- LocoLobo and Russell suggested the Allow Users To Edit Ranges option.
- Vijaykumanrdave suggested using Protection.
Display the Control Toolbox toolbar. (Choose Toolbars from the View menu, and check Control Toolbox.)
Click the Properties button on the Control Toolbox.
In the resulting Properties window, enter the input range as the Scroll Area setting.
Close the Properties sheet and close the Control Toolbox toolbar.