View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Param
 
Posts: n/a
Default Prevent User to unlock Sheet Tabs

Hi,

I have create data using several worksheets. Each one link with password
(macro). I uncheck sheet tabs (thur option command). User have to enter
password to preview or access to the worksheet. But user still can access to
worksheet after they check sheet tabs using option command (they can see all
sheet tabs at bottom. any idea how to solve this problem?
Tq