I am working on an excel sheet vba, I wanted to un hide the cells with a click on one cell above it without using the command button

Go to "software" and "spreadsheets"... section of this forum.

You will find an expert in VBA.