View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VoxBox-Richard VoxBox-Richard is offline
external usenet poster
 
Posts: 25
Default Password Protecting Sheets

Hello,

Is there a way I can password to protect a sheet so that before it can be
viewed a password has to be entered? I don't want to hide the tab and I have
already locked it (so the data can't be edited). I would like to protect the
viewing of the tab- I cant think of a way to do this using the normal excel
functions so VBA must be the answer. Can any one shed any light?

Cheers.

Richard