text: is it possible to prevent user from viewing the sheets code (macros) in excel, how?   when you are in the vba editor (press alt-f11), you need to select tools>vba project properties.  select the protection tab  here you can add a password just for viewing the code.  this method is more powerful than simply password protecting the sheet.