.PasteSpecial Paste:=xlPasteFormulas / protected cells

  • Thread starter Werner Rohrmoser
  • Start date
W

Werner Rohrmoser

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy formulas, not values 5
Having difficulty copying and pasting on VBA 3
Override protected sheet message? 4
hidden rows, column copy-paste 0
I'm Paste values stupid 4
Cell values to an array, then array transpose to another workbook 8
Keeping Conditional fromating When Emailing Using A Control Button 0
Code not working in a PROTECTED Worksheet 2

Top