copy and paste

[Guest]

Hello: I have a file with 52 worksheets tabs. I used a macro to create a
worksheet for each week of the year and have it name each tab by the week.
ie: 06-07-05
For some reason when I right click to copy any data or range of date the
paste feature is grayed out?? I even inserted a new worksheet and the copy
and paste works fine.
Any suggestions?

 

[swatsp0p]

Are these 52 sheets protected? (Tools>Protection>Protect Sheet

 

[Guest]

No they are not protected. already checked that.

 

[Dave Peterson]

There could be an event macro running in the background--based on changes or
selection changes.

If you open excel in Safe mode...

Close excel
windows start button|run
excel /safe
(and hit enter)

Then file|open your workbook

Do you have the same problem? (Opening in safe mode disables macros.)

===
And do you really mean that Paste is greyed out when you want to copy? (I
figured that was a typo in your post.)