Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 35
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 107
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 109
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 111
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 112
May
Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 35
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 107
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 109
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 111
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /home/frodr/public_html/msofficetuneup.com/wp-includes/functions.php on line 112
11
Preventing Users from Changing Parts of a Worksheet in Excel 2007
Microsoft Excel, Tips & Tricks Add comments
When you collaborate with other people on a workbook, you’ll often have parts of a workÂsheet that you don’t want altered in any way. You could activate Track Changes and then reject any changes made to those areas, but that’s extra work that you shouldn’t have to perÂform. Fortunately, Excel gives you an alternative: worksheet protection. With this feature, you can designate worksheet ranges to be locked, which means that other people can’t change, delete, move, or copy over those ranges.
Here are the steps to follow to set up protection formatting for worksheet cells:
- Select the cells that you want other people to be able to change. (Skip this step if you want to prevent changes to the entire worksheet.)
- Choose Home, Format, Lock Cell to deactivate this command.
- Choose Review, Protect Sheet (or Home, Format, Protect Sheet). Excel displays the Protect Sheet dialog box, shown in Figure 1.
- For added security, enter a password in the Password to Unprotect Sheet text box. This means that no one can turn off the worksheet’s protection without first entering the password.
- 1 Use the check boxes to select the actions unauthorized users are allowed to perform.
- 2 Click OK.
- 3 If you entered a password, Excel asks you to confirm it. Reenter the password and then click OK.
Figure 1 Use the Protect Sheet dialog box to activate your protection formatting.
NOTE
You might wonder why Excel makes the password for unprotecting the sheet optional.That’s because the concern here is worksheet integrity:You don’t want a user accidentally modifying or deleting formulas or data.When faced with a protected sheet,most users don’t automatically look to unprotect it, so protection without a password is almost always a safe option.
To turn off the protection, choose Review, Unprotect Sheet. If you entered a password, Excel displays the Unprotect Sheet dialog box. Type the password into the Password text box and then click OK.
Technorati Tags: preventing users, changing parts of worksheet, excel 2007
Popularity: 3% [?]
Recent Comments