Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Using the Active cell in one sheet for another sheet | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |