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?
Any help?