No. On eBay, these sell for $1-$3 as novelty items. They have no activation value. A "new" Retail Code is essentially an antique paperweight.
Navigate to the "Games" menu at the top or the "+ Add a Game" button in the bottom-left corner. Select "Activate a Product on Steam": No. On eBay