Prevent user from accessing certain worksheets

[csilabgirl]

Excel 2002

I have several sheets in a workbook. I have macros which do things to the various sheets, but I dont want the users to be able to click on the sheets directly to access them. Is there some code for that? Or alternatively I suppose if there was a way to lock the horizontal scroll bar so that that they could not even see the sheets, that would work also.

Thank you

 

[AlphaFrog]

You can hide the sheets. Your macros should work on hidden sheets.
Hide a sheet in Excel 2003/XP/2000/97

You could make a sheet Very Hidden so even the user couldn't unhide them from the menu...
http://www.ozgrid.com/Excel/hiding-excel-worksheets.htm

 

[csilabgirl]

Thank you. I think the very hidden is what I want