Hi
I have a large excel file with about 100 sheets in for a report.
There is an Admin 'lock all' & 'unlock all' button on the input sheet which lock and unlock all the sheets.
When the sheets are locked for use by the engineers I need 5 of these sheets to be able to paste and edit photos in.
I have got the code to work and all 5 sheets can have photos pasted in now.
Is there a way of condensing the code so I haven't 5 lots of the same code repeated? I have tried a few different ways but can't get it to work.
I've tried these:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
And a few other ways similar to these.![]()
Please Login or Register to view this content.
Kieran
Bookmarks