View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Werner Rohrmoser Werner Rohrmoser is offline
external usenet poster
 
Posts: 88
Default .PasteSpecial Paste:=xlPasteFormulas / protected cells

Hello,

when I try to paste formulas in a protected cell on a protected
sheet I get the information, that the sheet is protected and
that the operation is not possible.

When I do the same via VBA ".Copy" and then
"ActiveSheet.Range("C10").PasteSpecial Paste:=xlPasteFormulas" for
example
it works.

I'm surprised,is this standard?

Excel XP SP3
WIN XP SP1

Regards
Werner