Can't paste picture while Protect Sheet is on...

G

groundhog1

I am trying to paste a picture file (.bmp,.jpg) into some unprotected cells
using a macro. But, if I have protection on in a different area of the
spreadsheet, the picture doesn't come in. It only works if the whole sheet
is unprotected.

Now this same program was working before. I made some changes to a
seemingly unrelated part of the program, and now it doesn't work.

Anybody know what this is or how to get around it?

Thanks,
groundhog
 
G

groundhog1

I figured it out.
I just coded the program to turn off protection while I pasted and then
turned it on again.
duhh.
Thanks,
gh
 

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

Copying in sheet with protection with the use of a macro 5
"How do I un/protect sheet by macro program with password 5
How change unprotected cell formats on protected worksheets? 2
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
edit a comment while protect sheet is on the cell is unprotected 1
Macros between two seprate windows (excel) 2
User selects existing sheet to paste to 4
Changing a Chart on a Protected Sheet 2

Top