View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Sheet protection question

hi
with the file open...on the menu bar, click filesaveas
on the saveas dialog box, click toolsgeneral options...
here you can enter a passwork to open and a password to modify.

Regards
FSt1


" wrote:

Is it possible to protect excel sheet with a password such that
without password a user not only cannot modify the sheet but also
cannot view it?

Thanks for any input.

(I'm using excel 2007)