Excel Greys out on worksheets.copy

[DrJeckyll]

Hi guys

Can anyone tell me why Excel is greying out my spreadsheet when I copy from VBA code. I am taking advantage of the fact that when no before or after is specified excel creates a new workbook. The code is:

Worksheets("Output").Copy

I get a new book with a single sheet, "output", a copy of the sheet "output" in the original book, which is what I want, but its all greyed out. anyone got any ideas?

 

[SkipVought]

Exactly what do you mean by, "its all greyed out"?

Just the shading? It's just a format issue.

Shading AND something else as well? Makes the workbook unuseable in some way.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[DrJeckyll]

Ah, fair one. i meant that the text is grey not black. I can fix it by ammending the format, i'd just rather it didn't happen in the first place.

in the original book the text is automatic.

 

[SkipVought]

What version of Excel are you using?

What version was the original saved as?

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}