Strange AutoProtecting of cells

D

Darin Kramer

I have a macro which goes to an unprotected sheet(sheet A), selects
a3:b6, copies it, and pastes it in a protected sheet(sheet B). The
protected sheet only has protection on for formulae, and NOT over the
cells where the text is being pasted.

WIth protection off on both sheets works fine.
With protection on (in sheet B)get an error msg, effectively it is not
allowing the text to be pasted because it appears that the cells in
Sheet B (a3:b6)which were previously unlocked, are now locked.

any ideas...?

a3 to b6 in


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 

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

Select Text to End of Footnote 9
Create if partial match then copy and paste data from one cell to another 1
Having difficulty copying and pasting on VBA 3
Code not working in a PROTECTED Worksheet 2
userform exception error 4 textboxes 7
Protect sheet but allow user paste 0
Find values of a column in another and paste range of rows 1
Naming non-contigent cells with vba 5

Top