Sparkle
12-13-2018, 04:30 AM
I am using Excel 2016 32-bit as part of Office 365 ProPlus.
I would like to lock the pictures in my worksheet so they cannot be moved or resized but I do not want to lock objects. I have drop down ComboBoxes in the sheet too which people need to be able to type in and select options so couldn't use Protect Sheet and lock 'Edit objects'.
VBA code was suggested as a solution. Is it possible and can anyone help?
Thank you.
I would like to lock the pictures in my worksheet so they cannot be moved or resized but I do not want to lock objects. I have drop down ComboBoxes in the sheet too which people need to be able to type in and select options so couldn't use Protect Sheet and lock 'Edit objects'.
VBA code was suggested as a solution. Is it possible and can anyone help?
Thank you.