To make a new worksheet private, you need to click on the publish worksheet button.
Then click the button to make the worksheet private.
The lock icon will be displayed next to the name of the worksheet.
You cannot make private a worksheet that you have already posted as a public one (or found in the worksheet library).
However, to make such a worksheet private, you can copy and edit it. This function is available for PRO users ONLY.