Macro to unlock on click, display certain column data and refresh data

Hi

I'm using a Ron de Bruin macro, http://www.rondebruin.nl/win/s3/win006_4.htm

There is a list of Data on Sheet 1 and I have edited to protect the sheet. Password is 123.
I want to edit to make the following:
1) When I click on the button, it will auto unlock the sheet and after running the macro, it will protect back the sheet.
I have used the macro

Please Login or Register  to view this content.

However, it doesn't seems to be working.

2) How should I edit such that it will only show certain columns (e.g. Column A and C) instead of all data

3) Lastly, and how to edit to make the data be refreshed when new data is added or existing data is deleted?

I have attached the file for reference.

Hi, I'm very sorry for the trouble as I am still new to macro.

I have move the code to another file.
How can I disable the code such that if there is existing file, it will not show sheet(Error_0001) but it will refresh the sheet even when new data is added to the namelist sheet.

I have attached my current file for reference.

name list.xlsm

Hi, what I meant was when I first click the button to generate the unique value (gender). The sheet is fine. But when I click on the button again, it will generate another sheet with the sheet name (Error_0001). I just want the current sheet to refresh the data instead of generating another sheet.

This is what I mean (highlighted in yellow)
Capture.jpg

Hi, you are awesome. This is what I want..

And hope this will be my last question. If in the future I want to expand the data however, when I generate the unique value sheet, I only want certain column of data, how do I edit it?

Hi, you are awesome. This is what I want..

And hope this will be my last question. If in the future I want to expand the data however, when I generate the unique value sheet, I only want certain column of data, how do I edit it?