Unable to right click sheet tab

tcreach

New Member
Joined
Jun 13, 2008
Messages
12
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?
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Something else - I'm unable to right click a worksheet tab in any Excel file, not just this one. I had an issue opening some files this morning and some of the standard add-ins might have been disabled. Does this sound right? Is there an Excel option that prevents right clicking a worksheet tab?
 
Upvote 0

Forum statistics

Threads
1,214,948
Messages
6,122,420
Members
449,083
Latest member
Ava19

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