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.
|