protect method properties

  1. S

    How to protect the sheet but allow pivot table with vba

    Hello, I am trying to protect a sheet such that the options Select Unlocked Cells and Use PivotTable & PivotChart are enabled via VBA. I'm not finding much success on keeping these features on. Is there anyone that can point me to the right direction? Thanks.
  2. G

    Protected Sheet Link Issue

    Hi there all, I am protecting a sheet in which is contained a link to an embedded word document which has instructions for certain parts of the form. When I add the protection it causes an issue whereby if you click anywhere on the page, it opens the word document, clearly an issue. It's not an...
  3. L

    UserInterfaceOnly - protection not recognised?

    Hi All I allway write all my code in lowercase, so that when it capitalises I know I have spelt it correctly. However I have been looking for a better way to protect my workbook to avoid the endless looping. And found the UserInterfaceOnly property which seems to state it will allow VBA even...
  4. V

    Macro isn't working after set .Protect UserInterfaceOnly:=True

    Hello everyone, This being my first post, I hope this forum can be helpfull to me, and I can to be helpfull to others. Please correct me if my style of posting is unclear or unjust. I have a problem I am looking into for a day now, and still I can't lay my finger on it: I have a data transfer...
  5. G

    Protect Method Properties

    Hi All - I'm a little confused by what is happening when I use the 'Protect' method in my "Worksheet_Open" event. I have the following code and what I'm trying to accomplish is allow the end-user to Edit Scenarios and Drawing Objects. After running this code, I go and check the Protect...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top