Cisco HTML WSUS Android (1)
Bootstrap (1)
Certification (3)
Cisco (1)
Database (3)
Development (2)
Digital Photography (1)
Freeware (2)
General (14)
git (1)
HTML (2)
Javascript (1)
Linux (6)
MCSE (3)
Microsoft (6)
MySQL (2)
Network (4)
Office Suite (2)
Oracle (1)
PHP (2)
scripting (2)
Security Threats (1)
SEO (1)
Software (2)
Spyware (1)
Training (1)
Utilities (1)
Virus (1)
Web Development (2)
Word Press (1)
WP-Syntax (1)
WP-Theme (2)

WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.

Recent Posts

Excel – Protect cell formats   August 11th, 2015

Text from

Format the Sheet

The first thing you want to do is go ahead and format the sheet they way you want it to look.  Add borders, cell shading, bold, italics, anything.  Once you finish this walkthrough, you won’t have to worry about setting it again.

Unlock the Cells
Excel provides an easy way to unlock your cells for editing.

  1. Select all the cells you want users to be able to edit.
  2. Right click and select Format Cells from the right-click menu.
  3. Click on the last tab, “Protection” and uncheck the “Locked” checkbox (it is checked by default.

You cells are now unlocked and you are ready to protect your sheet.

Protect the Sheet
Protecting the sheet can be done in one easy step.  From the main menu, select Tools–>Protection–>Protect Sheet.  If you want the default settings without a password, just hit OK and your formatting is now protected while still being able to change the cells contents.

You’ll notice however there are many other options available for you to choose.  Check the options you want the user to be able to do (You’ll notice “Format Cells” is unchecked by default).

  • Select locked cells (Default: Checked)
  • Select unlocked Cells (Default: Checked)
  • Format Cells (Default: Unchecked)
  • Format Columns (Default: Unchecked)
  • Format Rows (Default: Unchecked)
  • Insert Columns (Default: Unchecked)
  • Insert Rows (Default: Unchecked)
  • Insert Hyperlinks (Default: Unchecked)
  • Delete Columns (Default: Unchecked)
  • Delete Rows (Default: Unchecked)
  • Sort (Default: Unchecked)
  • Use AutoFilter (Default: Unchecked)
  • Use PivotTable report (Default: Unchecked)
  • Edit Objects (Default: Unchecked)
  • Edit Scenarios (Default: Unchecked)

The only other decision left to make is whether you want password protection on the sheet as well.  If you don’t put a password on the sheet protection, any user can turn it off the exact way you turned it on.

Display headers in outlook message   August 11th, 2015

Outlook 2007/2010/2013
You can display full headers by double clicking on a message so that it opens in a separate window (not the preview pane).

Start Outlook.
Double-click the message for which you want to view full internet headers.
Click Options (2007) or Tags (2010/2013).

message options button /

The Message Options dialog box is displayed. The internet headers are shown in the Internet headers field at the bottom of the dialog box.

java.lang.NoClassDefFoundError   January 2nd, 2011


This occurs because the classpath is not setup or referenced correctly.

Executing your program using this command should correct the problem:
java -classpath . helloworld

where helloworld is the name of your compiled class.

This tells java that your classpath is your local directory.

Microsoft BGInfo 4.10   August 15th, 2007

GBInfo will display your computer information on the screen background.

Oracle SQL Developer   July 24th, 2007

Oracle SQL Developer is a free graphical tool for database development.