View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter McNaughton Peter McNaughton is offline
external usenet poster
 
Posts: 5
Default How can I test when any worksheet within a workbook is selected

Hi
Thanks but it's not what I am after. When any worksheet within a
workbook is activated I would like to be able to trap which one it is
and if necessary make the visible property = false.

Note: I am using the username to determine who is able to see what
sheet.

I have about 10 worksheets that I want to be able to control in this
way (and about 400 workbooks).

Peter