I have written a macro to generate reports in few sheets of a
workbook.Is there a way to prevent users from seeing the macro and at
the same time allowing them to view/edit the rest of the workbook.

Also is it possible to protect selected sheets in a workbook?