View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LDanix LDanix is offline
external usenet poster
 
Posts: 19
Default Macro for making worksheets visible.

I have 12 agents that I manage. I want to create a workbook that includes
each person's vacation accrued and spent on separate worksheets.

I want to make all the worksheets invisible upon load of the workbook (I
figured that out). I want to give each agent access to their own worksheet
without being able to view the other agents.

I have each worksheet named as the agents' employee ID numbers. I want to
create a macro that will make visible a worksheet based on the employee ID
number an agent types in somewhere.

Thanks,
Luke