image bank

[jasman]

Hi. I have a workbook where i have created a programme which contains a dataset of images in different colours and a macro which transfers the images onto another worksheet depending on the colours chosen by the user.
I have now protected the worksheets ( only the cells which contains the images), but when I hit the macro button to create image it doesnt transfer the images anymore?

any ideas?

thanks

 

[GlennUK]

Show your macro code.

 

[jasman]

Private Sub CommandButton1_Click()
Application.ScreenUpdating = False


If Sheet11.Cells(3, 2).Value = "X" Then
ActiveSheet.Shapes("Picture 1").Select
Selection.Copy
Sheets("PBOM").Select
ActiveSheet.Range("f9").Select
ActiveSheet.Paste
Sheets("Suspension").Select


ElseIf Sheet11.Cells(3, 2).Value = "U" Then

ActiveSheet.Shapes("Picture 6").Select
Selection.Copy
Sheets("PBOM").Select
ActiveSheet.Range("f9").Select
ActiveSheet.Paste
Sheets("Suspension").Select


ElseIf Sheet11.Cells(3, 2).Value = "P" Then

ActiveSheet.Shapes("Picture 3").Select
Selection.Copy
Sheets("PBOM").Select
ActiveSheet.Range("f9").Select
ActiveSheet.Paste
Sheets("Suspension").Select


ElseIf Sheet11.Cells(3, 2).Value = "M" Then

ActiveSheet.Shapes("Picture 8").Select
Selection.Copy
Sheets("PBOM").Select
ActiveSheet.Range("f9").Select
ActiveSheet.Paste
Sheets("Suspension").Select

End If

End Sub

 

[GlennUK]

Well, one easy way is to unprotect your sheet in the code, do the copying and then reprotect the sheet afterwards, if you want to leave your sheet protected after the macro runs.

 

[jasman]

i need it to be protected all the time- well as long as it doesnt let the user delete or alter the images in the cells is the main thing. However the problem is the macro I have copy and pastes the images onto another sheet which doesnt work if protected..... thanks

 

[jasman]

-

 

[GlennUK]

I suggested that you could unprotect ( in the macro ), do the processing ( in the macro ), and reprotect ( in the macro ) .... how would that let the user delete or alter images? It wouldn't as far as I can see.

Can you explain why my suggestion is not sufficient?