Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy sheets
I clicked the tab of a sheet and then right clicked and chose 'Move or Copy'.
I checked the box of 'Create a copy' and clicked 'OK'. But nothing happened. The file has only 3 sheets total. Before, I accidently ran a macro to create many sheets, but I deleted all of them with 3 sheets left. I have never encountered such situation. This method has always worked until today. Thanks for help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy sheets
Hi,
check that when you chec the box create a copy , the first line where it says To Book, has the name of the worksheet you are using, otherwise you are creating a copy in another workbook "Scott" wrote: I clicked the tab of a sheet and then right clicked and chose 'Move or Copy'. I checked the box of 'Create a copy' and clicked 'OK'. But nothing happened. The file has only 3 sheets total. Before, I accidently ran a macro to create many sheets, but I deleted all of them with 3 sheets left. I have never encountered such situation. This method has always worked until today. Thanks for help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy sheets
Thanks for the quick response.
I closed all other files. The first line of the 'Move or copy' box did point to the same file I am using. It just didn't work. "Eduardo" wrote: Hi, check that when you chec the box create a copy , the first line where it says To Book, has the name of the worksheet you are using, otherwise you are creating a copy in another workbook "Scott" wrote: I clicked the tab of a sheet and then right clicked and chose 'Move or Copy'. I checked the box of 'Create a copy' and clicked 'OK'. But nothing happened. The file has only 3 sheets total. Before, I accidently ran a macro to create many sheets, but I deleted all of them with 3 sheets left. I have never encountered such situation. This method has always worked until today. Thanks for help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy sheets
Hi Scott,
sorry for not being able to help you but make not sense at all, it should be creating a copy, last resource I can think is right clikc in the mouse on the tabs and see if there is any tab to be unhided "Scott" wrote: Thanks for the quick response. I closed all other files. The first line of the 'Move or copy' box did point to the same file I am using. It just didn't work. "Eduardo" wrote: Hi, check that when you chec the box create a copy , the first line where it says To Book, has the name of the worksheet you are using, otherwise you are creating a copy in another workbook "Scott" wrote: I clicked the tab of a sheet and then right clicked and chose 'Move or Copy'. I checked the box of 'Create a copy' and clicked 'OK'. But nothing happened. The file has only 3 sheets total. Before, I accidently ran a macro to create many sheets, but I deleted all of them with 3 sheets left. I have never encountered such situation. This method has always worked until today. Thanks for help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy sheets
I closed and then reloaded the Excel Application, and reopened the file. It
worked. Just don't know why it happened that way. Anyway, thanks for your help. Scott "Eduardo" wrote: Hi Scott, sorry for not being able to help you but make not sense at all, it should be creating a copy, last resource I can think is right clikc in the mouse on the tabs and see if there is any tab to be unhided "Scott" wrote: Thanks for the quick response. I closed all other files. The first line of the 'Move or copy' box did point to the same file I am using. It just didn't work. "Eduardo" wrote: Hi, check that when you chec the box create a copy , the first line where it says To Book, has the name of the worksheet you are using, otherwise you are creating a copy in another workbook "Scott" wrote: I clicked the tab of a sheet and then right clicked and chose 'Move or Copy'. I checked the box of 'Create a copy' and clicked 'OK'. But nothing happened. The file has only 3 sheets total. Before, I accidently ran a macro to create many sheets, but I deleted all of them with 3 sheets left. I have never encountered such situation. This method has always worked until today. Thanks for help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move or copy sheets doesn't copy format | Excel Worksheet Functions | |||
copy sheets | Excel Discussion (Misc queries) | |||
Not Being Able to copy sheets | Excel Discussion (Misc queries) | |||
Copy Sheets | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions |