Allowing manipulation of images but not form controls?

mcomp72 · Mar 21, 2019

Hi everyone. On my worksheet, I have a button that allows the user to add image(s) to a worksheet. When they press the button, the worksheet stays protected BUT it allows for the manipulation of ‘Drawing Objects’, using the below code. This way, they can insert the images, but cannot change certain parts of the sheet that need to remain protected.

Code:

  ThisWorkbook.Sheets("CoverSheet").Protect Password:="Password123", _
          DrawingObjects:=False, _
          Contents:=True, _
          Scenarios:=True, _
          AllowFormattingCells:=False, _
          AllowFormattingColumns:=False, _
          AllowFormattingRows:=False, _
          AllowInsertingColumns:=False, _
          AllowInsertingRows:=False, _
          AllowInsertingHyperlinks:=False, _
          AllowDeletingColumns:=False, _
          AllowDeletingRows:=False, _
          AllowSorting:=False, _
          AllowFiltering:=False, _
          AllowUsingPivotTables:=False, _
          UserInterfaceOnly:=True

I would now like to add a spin button (form control) to this worksheet. However, when I do, the user can move/delete the spin button with DrawingObjects set to False as in the above code. I’m wondering if there is a way to protect the spin button, but to still allow the user to manipulate images they have inserted (moving them around, changing the size, etc)?

DanteAmor · Mar 21, 2019

Click right on spinbutton / Format Control / Tab Protect / check Locked

DanteAmor · Mar 21, 2019

Code:

ThisWorkbook.Sheets("CoverSheet").Protect Password:="Password123", _
          DrawingObjects:=[B][COLOR=#0000ff]True[/COLOR][/B], _
          Contents:=True, _
          Scenarios:=True, _
          AllowFormattingCells:=False, _
          AllowFormattingColumns:=False, _
          AllowFormattingRows:=False, _
          AllowInsertingColumns:=False, _
          AllowInsertingRows:=False, _
          AllowInsertingHyperlinks:=False, _
          AllowDeletingColumns:=False, _
          AllowDeletingRows:=False, _
          AllowSorting:=False, _
          AllowFiltering:=False, _
          AllowUsingPivotTables:=False, _
          UserInterfaceOnly:=True

In the spinbutton code you have to unprotect the sheet, insert image and re-protect the sheet, but with DrawingObjects:=True

mcomp72 · Mar 21, 2019

I want the user to be able to manipulate the image -- change the size and move it around the sheet. So for that, don't I need DrawingObjects set to False?

And if I have DrawingObjects set to False, at that time the user would be able to delete or move the spin button, correct?

DanteAmor · Mar 21, 2019

perform the test with = false and check - uncheck propeetie

Allowing manipulation of images but not form controls?

mcomp72

Active Member

Excel Facts

DanteAmor

Well-known Member

DanteAmor

Well-known Member

mcomp72

Active Member

DanteAmor

Well-known Member

Similar threads

Forum statistics

Share this page

Allowing manipulation of images but not form controls?

mcomp72

Active Member

Excel Facts

DanteAmor

Well-known Member

DanteAmor

Well-known Member

mcomp72

Active Member

DanteAmor

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock