How to hide Sheet2 without being discovered

1. First Go to Tools, Macro, Visual Basic Editor as shown in diagram 1.

2. In the Visual Basic Editor, click on Project Explorer and Properties window if you do not have the layout shown in diagram 2.

3. In the project explorer, expand VBA Project (Book 1) by clicking on the "+" sign on the left of the label. Click on the "+" on the left of the label Microsoft Excel Object.

4. Select Sheet2 ( See diagram 3). When you have done that, you should see some details as shown in diagram 3.

5. Click on the last property called visible and select the option 2-clVeryHidden. (see diagram 4)

6. Close the visual basic editor.

7. Sheet2 has disappeared. Try to check to see if it is available for unhide in the normal Format, Sheet, unhide.

 

Hope you are amazed by this revelation.

 

 

 

 

 

What experts don't tell you about hidden worksheets (revealed)

Did you managed to find the content hidden in Sheet2?

If you have not, here's how. Enter the formula "=Sheet2!A1" in Sheet1. Copy and paste the formula in the range "A1:M20". You should be able to see text "BINGO. YOU HAVE MANAGED TO FIND THIS WORKSHEET." in Cell C5.

To make it nicer, you can go to Tool, Options and click on the view tab. Click off the check box on zero value. (See diagram). The zeros all disppear showing the text on Sheet1 clearly.

So how did I make sheet2 disappear such that it will not even show up using the Format, Sheet, unhide approach? Find out tomorrow.

What experts don't tell you about hidden worksheets

Download this excel file and find the content stored in the hidden sheet2. Come back tomorrow if you don't know how to do it.

Setting Date Format

The most common date format used by many are dd-mmm-yy or dd/mm/yy or mm/dd/yy. What has been neglected or remain unknown to most users is that Excel can return the day (e.g. Mon) of the date. When you entered "ddd" in custom format for a particular cell that contains a date value, the day is returned (see diagram). If you entered "dddd", the full string (Monday) is returned. If you entered mmm, the 3 characters month name is return. By entering 4 "m", the full month name (e.g. January) is returned.

Using a list of recipients in Excel to send email

Imagine you are given a list of email addresses in an Excel worksheet (sample as shown).

abc@baxter.com

def@nea.gov.sg

ghi@hotmail.com

jkl@yahoo.com

mno@hotmail.com

pqr@yahoo.com

stu@gmail.com

You are told to send email to all the names in the list. Are you going to send the email one by one? If you are, then there is a better solution for you. You can create a email list thru the use of Excel Function called concatenate or simply use the symbol "&". Here is how:

1. Enter the formula to reference the first email address. Asuming that the first email address is in cell A2, then enter the formula "=A2" in cell B2.
2. In cell B3, enter the formula "=B2&";"&A3". The "&" in the formula is to join the content in cell B2 together with Cell A3 and at the same time add the symbol ";" between them. (see diagram)
3. Copy the formula down to the last row.
4. Copy and paste the content in the last row as values.
5. Copy the list of email addresses and paste it in the To, CC or BCC field in your email message.
6. You are ready to send the info to all those in the list.