password protect sheets

Thanks Leith, works nicely. how would the same method work if as example, if I were to forward the workbook to another user (I have a running macro that enables the user to search for a particular set of data on one of the xlSheetVeryHidden) but I don't want them to be able to simply make the sheet hidden to view all the data on the page. (myself I would be required to update those pages weekly). I was thinking the password protect method would enable someone to simply run the macro to retrieve certain data required without access to the remainder of the information stored in the pages and I could just access those sheets and update accordingly. Or could I simply put a password feature on the page that contains the macro to prevent anyone from doing anything but run the macro but enable me via the password?

Hi Leith, Hopefully this will make more sense. As you can see by attached. Sheets 1-5 are hidden with only sheet 6 visible which runs the macro. When searching for a match via the combobox/textbox a result is displayed in the listbox field. However if I were to forward this to someone, they could easily go to the develop tab and make the pages 1-5 visible to see the full data that will be in those sheets. This is what I want to prevent but enable me to update those sheets if necessary. I was thinking with a password protect on the sheets, this would prevent anyone from viewing the full information in those sheets except myself (via password) when updates are needed.

Thanks Leith! Worked like a charm. And here I thought I would need alot of coding lol. Much appreciated!