View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna Anna is offline
external usenet poster
 
Posts: 132
Default activate/deactivate macro depending on who's the user

in my office we have a shared drived folder that is used by different
users,we store excel worksheets in the shared folder. Each user have to log
in to the PC with a different ID to start using the it.

I need a macro to automatically hide/unhide rows in the excel worksheet
depending on who the user is.

How should i write the macro? Please help.