Hi MarvinP
Thank you for the advice. I got what I desire. It works great!
However, I have one more question. Is there a way to restrict view of individual staff worksheet with a password.
Which means if anyone open the workbook, only the "Front page" can be view freely and other worksheets require a assword to view it.
I tried to protect and hide but it cant work.
Please help. Thanks.
Jane[COLOR="Silver"]
Bookmarks