Insert sheet and Move/Copy sheet disabled!

M

Moriaty

New Member
Joined
Jul 3, 2008
Messages
15
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 :eek:. 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...:confused:

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

Thanks!
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
See if this helps - open the VBEditor (Alt+f11), open the Immediate Window (Ctrl+G) and type in:
Code: 
Application.Commandbars("Ply").Reset
and press enter.
 
Upvote 0
Thanks for the reply... i tried to repair the Office package again and after that, suddenly there was a power failure so the computer was reset.... Although - as i know - the Office package does not require a computer restart, after a new reboot due to the power loss, the options were active again... :pray:

(y)
 
Upvote 0
I was unable to insert a worksheet and the solution was that the workbook was protected. I unprotected the workbook and was then able to insert and copy worksheets.:)
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
VBA to insert rows in sheet 2 (parts list) at row 5,& move existing datas down while inserting new rows,when drop down value is selected on E4 sheet1.
Replies
8
Views
303
nscaria00
N
M
  • Question
Macro: Copy/rename sheet and create hyperlink. Error. Are shared documents not macro friendly?
Replies
1
Views
185
Micron
M
MikeMcCollister
  • Question
Copy Sheet Creates Copies of Lambda Functions in Name Manager
Replies
6
Views
160
MikeMcCollister
MikeMcCollister
Agnarr
  • Question
VBA problem with creating new sheets
Replies
0
Views
338
Agnarr
Agnarr
I
  • Solved
Unprotect - UpdateAll - Protect Jumps to another sheet
Replies
5
Views
533
Michael M
Michael M

Forum statistics

Threads
1,214,659
Messages
6,120,786
Members
448,992
Latest member
prabhuk279

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top