Cut and Paste into spreadsheet with locked formulas

O

Oak

Hello,
I need to cut and paste into a spreadsheet where the formulas are locked. I
have selected Format>cells>protection and cleared the Locked checkbox for the
cells where I want to cut and paste. I can enter data OK but it will not
allow me to enter via cut and paste. Any ideas?
Thanks
 
D

David McRitchie

Record a macro turning protection off, do what you want in the macro, then turn
protection back on.

--
 

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

How to paste the same cell one tab over 1
Prevent Cut and Paste 3
lock cell font 0
Place picture in Excel cell 0
Linking data in MS Word into Excel 5
Cut & Paste Locked Cells 0
Protect formulas which reference to unlocked cells in protected s. 5
Disabling "cut" function - version 2003/2007 1

Top