Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Cant Copy Or Move Sheet - Greyed Out

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Afternoon all,

Can someone take a look at this for me? This workbook, which is unprotected, will not let me copy or move an existing sheet, or create a new one.

What have I done?

View Answers     

Similar Excel Tutorials

Change the Order of Tabs in Excel
How to change the order of the tabs in your spreadsheet. This is rather easy to do and makes your spreadsheets much ...
Linking Cells in Excel
In this tutorial I am going to cover how to link cells together. This is a useful feature of Excel as you can link ...
How to use Vlookup Across Multiple Worksheets in Excel
This tutorial shows you how to use the Vlookup function across multiple worksheets within Excel.  This means that y ...
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forenames, surnames and ages. As ...

Helpful Excel Macros

Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Save the Current Worksheet as a New File in the Current Folder
- This Excel Macro saves the currently visible worksheet into the SAME folder as the current file. It is different from
Replace Formulas with Values (For The Entire Workbook)
- This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to
Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a
Create a Bar Chart With a Macro in Excel
- Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data

Similar Topics







Hello...

For some reason I no longer have the ability to move worksheets in a workbook which has been evolving for some time now.

When I right click on a sheet tab, the "move" and "copy" sheet functions are greyed out.

Any help here?

Thanks in advance!

BobMc


I want to copy a worksheet and insert it on another tab in the same file, when I click on Edit the 'Move or Copy sheet' option is greyed out so I cannot select it. I have other files open and can move or copy successfully, so the problem must lie in this particular file, how can I fix this?
Thanks.


HI
I am working on a userform and i wont to be abel to use the move and copy, to move a sheet from one workbook to another workbook. most of my users are not that good at Excel, and with the form up you can not use excel move and copy. or a way to have a list of all my sheets in a comboboxes or list boxes to pick the sheet to move.


xl2007 here...
I often use the above procedure to create an identical copy of a sheet to the right of the existing sheet.

I just went to VBE and in the ThisWorkbook section selected the NewSheet Event with a oniner Msgbox "A New Sheet was just created"

I then did the rgt-click on the sheets tab, selected Move/Copy sheets; checked the COPY at the bottom, also after current sheet and It CREATED the New Sheet, BUT - My message DID NOT APPEAR!! Is this action Not subject to this Event?

Any help appreciated...

Jim


Excel 2003 on WinXP SP2 - There is one workbook that will not allow sheets to be copied. There is no error message generated when doing this. New spreadsheets and other existing spreadsheets allow copying. This workbook does not have any macros, is not protected, and the sheets are not protected.

Right-clicking on the tab, then left-clicking "Move or copy". In the dialog, we are keeping it in the same workbook, and making sure that the "Create a copy" box is checked. The PC seems to do something for a few seconds, but nothing is copied.

Using the same "Move or copy", we are able to move the sheets to a new workbook. However, after doing so, we are still unable to copy the spreadsheet in the new workbook. I think that it narrows this issue down to the sheets in this workbook, but I am at a loss on what to look for next.


I have a sheet within a workbook that I copy and create a duplicate within workbook ( "Test") becomes "Test (2)" after creation.

Without doing anything to "Test (2)" I then attempt to create a copy of "Test (2)" and receive the message, "a formula or sheet you want to move or copy contains the name "XXXX"...." the "XXX" refers to a team member who left years previously and their name is not present anywhere, that I can locate, within workbook!!!!

If I return to "Test" I can create another copy with no problem i.e "Test (3)" but if I again try to copy "Test (3)" I again receive the message.

anyone know why this occurs and if there is anywhere else I should consider looking within workbooks. I have tried lists, formulas, scripts etc but unable to find any reference to "XXXX" (named individual).


When I try to copy sheets in a workbook to another sheet in the same workbook
I get the following error message:

A formula or sheet you want to move or copy contains the name 'aa', which
already exists on the destination worksheet.

This repeats many, many times until it ends with something like
'zzzzzzzzzzz'. How can I preclude this from happening? I don't have any
named ranges in the sheet/workbook that this occurs in. Has anyone seen this?



Is it possible to disable the ability to right click on a tab and select "move or copy"?

I've already disabled the Edit->Move or Copy Sheet... feature on the menu.

I'm sending a file to users that I don't want them to print. The workbook itself has the print function password protected and copy/paste disabled. Any help would be appreciated.

Thanks!

To clarify I already have the printing part solved, but I don't want them to be able to move or copy the tab or tabs to a new workbook and print from there.


I use Excel 2007 on XP/SP3.
I work with an application that 'dynamically' builds an Excel Spreadsheet.
What I have been doing is clicking on the sheet tab, then doing a 'Move or Copy' to move the sheet to another spreadsheet that I'm working on. Well, something has changed (beyond my control) in this application. When I go to the 'Move or Copy' dialog I can no longer select the Book where my 'big' spreadsheet is. The only Books that are available in the dialog is the one where that sheet came from. I suspect that what is happening is that a new instance of Excel is being started and one instance isn't aware of the other. But whatever the reason I need to recreate this move function because I do it all the time. I need the sheet to look exactly the same after the move. I've tried various kinds of copy/paste. I can get the data over but I can't get the formatting.

I'll try anything. If there is an add on or something else that will give me this function back I'd be more than willing to try it. But any help will be gratefully accepted.

Thanks in advance!


Hello,



I need to find a way to disable certain Excel functions, like the Move or Copy sheet action. I would like to ask for some good advice on how to do this.



Also, although I understand this is highly unlikely, but is there any way to control the parameters shown in the Move or Copy form? (from Edit --> Move or Copy sheet). Is there ay way to remove the item "(new book)" from the "To Book" dropdownlist?

If not, perhaps I could disable the dropdownlist altogether? This way moving or copying could be done only within the current workbook.



Thanks for reading!


I have some macro. It works on data which is on workbook with this macro and on external excel file. In this workbook macro is adding some text and formatting cells.

I can not copy worksheet (anywhere), but I can move it (option "create a copy" is unmarked). Workbook and worksheets are unprotected. There is not any message or error. After moving worsheet into another workbook I stil cannot copy its elsewhere. I cannot copy its manually nor automatically (using VBA).

If anybody knows how solve this problem?


Hi,

i have posted something similar earlier today but this is alittle different.
I have a sheet called Template in a workbook. i need to be able to issue a
macro that will copy it and move it to the far right after all other sheets.
Then rename it 1 number above the last sheet. i.e. if the last sheet was 2567
then my new copied shett will be 2568.

regards,

N.S.




I trying to right click on move or copy a sheet at the bottom of the page,
but the move or copy isn't highlighted anymore. Insert, delete, rename or
move or copy is in light gray and won't let you click on it to choose it.
Any help would be greatly appreciated.

Thanks,

Henry



I am using Excel 2000 SR-1.

On certain Excel documents, whenever I try to copy a workbook by clicking on Edit - Move or Copy Sheet, I get a warning that says:


A formula or sheet you want to move or copy contains the name "_____", which already exists on the destination worksheet. Do you want to use this version of the name?

To use the name as defined in the destination sheet, click YES.

To rename the range referred to in the formula or worksheet, click NO and enter a new name in the Name Conflict dialog box.

In a particular workbook, it says there are 10 formulas or names that will be overwritten.

In all cases, either there are no named ranges, formulas or macros in the workbook that match the given name or there aren't any at all in the workbook.

How can I identify these formulas or names and get rid of this problem?

Thanks.


Hi

I have two sheets in an existing workbook that I would like to copy to a new book (as in manual "Move or Copy"

I have used ActiveSheet.Copy to copy one sheet, but need the code to copy the two to a new

Sheets are Sheet2 and Sheet14

or

Worksheets("Sales") and ("Weekly")

Thanks for any help

Mark


I'm trying to make a copy of a worksheet (just manually, via either or 'edit / move or copy sheet'), within the same workbook, but am unable to. I thought the problem might be because of my having the worksheet protected, but I unprotected it, tried to copy, and still no luck. It's a workbook I created, and other than the worksheet being password-protected, I don't recall any special settings I would have created. Any ideas where I might look for what's causing the problem?? I'm using Excel Pro 2003, SP3.


I am working in Excel 2007 with a workbook that is saved as an Excel 2003 file (.xls extension). The workbook has a seperate tab for ever person in my office (around 30 people) to post their workschedule. It is a shared workbook so everyone can access it at the same time. I need to add a new tab for a new employee so I had everyone exit from the workbook and then I unshared the workbook. I am trying to copy and paste one of the worksheets so the formatting is the same. I usually just right click on the tab (i.e Sheet1), select "Move or copy", and then check the box to copy the worksheet. When I try to right-click the tab I get nothing. I am able to right click in a cell just fine. The workbook is unprotected and I don't know how to fix this.

Any help?


Hello,

A colleague of mine has the following problem:

When he opens a new workbook and he right clicks on a sheet, all functions are available except for the "Move or copy...". The latter is gray.
The workbook is not protected, as it is a new one.

Does anyone knows how to solve this?

Thanks in advance,

Mikael


Hi,

Can anyone tell me how to move/copy a worksheet to a new workbook and keep the values made by the formulas but not have the formulas included on the new sheet?

In our current method, we copy/move the sheet to a different workbook, sometimes 60 or more, then we must copy,paste special, values, in the columns that contained formulas.

Any help would be greatly appreciated

Mike


I have what may be a 3 part question so help on either one is appreciated.

I have 102 separate workbooks that need to be reorganized. I have attached a sample to this post but what I am looking to do is create a copy of the existing workbook and remove some data and reorganize the data that remains.

So the steps I am looking to accomplish are these:

1 - Create a new workbook with the same name (or samename1.xls).
2 - Copy specific content to the new workbook. The data I am looking to remove is A1:H3. Move the value of A4 to the new A1 and A6 to the new B1.

And lastly,

3 - Shift the data in B4->H4 to the new A2->G2 (and all rows that have data).

Thanks in advance for the help,

Dan


Hi,

I've built a tool via a pivot table with several macros that work either in the background or via form control buttons and all of a sudden I'm getting an error when I try to create a new tab/sheet in the overall workbook that 'That command cannot be used on multiple selections'.

I've checked pretty thoroughly that there's no multiple selections in play via the following methods:
Group and ungroup the tabs Clicked in a separate cell without having the Ctrl key held down Pressed ESC Run a new macro with just 'Application.CutCopyMode = False' Tried to execute a macro with 'Application.DisplayAlerts = False' 'Sheets.Add' 'Application.DisplayAlerts = True' which got still came up with the error Holding Ctrl and moving a current sheet to the end Right clicking a current sheet and selecting Move or Copy and Copy and Move to the End Shift + F11 Move or Copy and Copy from a fresh Excel to this sheet Nothing seems to work. And I'm completely stumped - any ideas?


This is the error i get by doing> edit> move or copy sheet

A formula or sheet you want to move or copy contains the name 'HTML', which already exists on the detination worksheet. Do you want to use this version of the name?

All I want to do is copy a sheet into the same book. If I click yes, two more errors pop up.

Suggestions????


Is there a way to password protect a workbook but still allow users to still right click a sheet tab and either rename it or delete it?


I am basically trying to block the move/copy feature to prevent a sheet from being copied to a new workbook and the currently passworded VBA codes from being exposed.


Hi all,

recently i saw that the Insert and Move/Copy sheet options from right click on sheet tab menu or the Edit menu are disabled . This is not only at existing documents but also when i open a new excel document. So NO VBA scripts behind that eventualy disables these menus and also NO protection is active on the document...

I tried to repair the Office package... no luck... does anyone have an idea...?!? ... by the way, i have Office 2003...

Thanks!


In an Excel workbook I use that has several sheets, when I copy/paste/create a sheet into the same workbook twice, I get a message box that reads:

A formula or sheet you want to move or copy contains the name '----' which already exists on the destination worksheet. Do you want to use this version of the name?
*To use the name as defined in the destination sheet click YES
*To rename the range referred to in the formula or worksheet click NO and enter a new name in the name conflict dialogue box.

I have to click YES 26 times to get through all the names that pop up.

I have no idea what this is all about. I have used EDIT/Find to try to locate the name in both text and formulas, but they are not found. They are not macros either.

Has anyone else seen this message? Can you direct me to find where the conflict is?

Any help would be appreciated.