View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
belvy123 belvy123 is offline
external usenet poster
 
Posts: 71
Default Copy sheet and make new sheet active

Hi All

I have a worksheet that I want to be able to do this.
I want to use a macro using CTRL(A) to copy a sheet in my workbook and to
make it active. I want the sheet that it copys from to be hidden and to use
the same sheet each time that a copy is made. This way I have a new blank
sheet to start off each time I need a new sheet. I want to do this so the
people on my team at work do not have to do anything more that a CTRL(A) and
be able to start in to work and not have to go to the top menu and select
insert etc.

Thanks
crunhin numbers