Copying Worksheets

[Neil169]

Hi. I have a user who has a Excel Spreadsheet with numerous Worksheets
within. It will not allow him to copy worksheets from this spreadsheet to a
new spreadsheet but it will allow him to move them. The file was originally
created in Excel 97 but he now uses Excel 2003. I can copy worksheets using
Excel 97 but don't want to downgrade the user.

The spreadsheet is not protected in any way and there are no hidden sheets.

Any help appreciated.

 

[ryguy7272]

Just hazarding a guess here. Can you right-click on a tab and then click on
Move or Copy, then choose Move selected sheets > Create a copy. Get all
sheets in a new workbook, and just use that new book.

Does that work for you?

Regards,
Ryan--