After I hide the sheet with password (lock project for viewing) and save as Macro Enabled workbook, and it functions okay when I need to let the sheet visible.
However, when I save the excel as a Excel Workbook, it will be no need to type the password when I want it to be visible.
How can I solved the problems? Thanks