Unable to run code in between "Unprotect" and "Protect" object.

Hi,

I am trying to select a report filter in between the "Unprotect" and "Protect" object. The issue is the report filter won't stay visible long enough to make a selection before it closes and protects again. I have tried to do the wait command in order to prolong the time that the report filter stays open, but that doesn't work either because it won't allow you do make a selection during the wait.

The code will unprotect and run if I leave off the, "Protect Password:="Secret". But that will just leave everything open for edit which is what I don't won't. I understand that the object can still be edited or modified during the open window in between "Unprotect" and "Protect" keywords. But this is the only method that I've had any measure of success with. Any/All suggestions are welcome.


The code I am using for this is pretty simple...something like:

Please Login or Register  to view this content.

Hi,

Its actually "Sheet1". But I haven't needed to specify the sheet name in this part of the code in order to actually protect/unprotect. I have even tried the "UserInterfaceOnly:=True" option but to no avail.

Thanks for the response,

So I have specified the worksheet before and it didn't help the issue that I am asking about. And I use "ActiveSheet" because it is the only way I know how to have a user dynamically choose chart functionality through a combo box and vba code. I am looking for help or sample code to help with my original issue that I posted, which is, I can't perform the report filter functionality in between unprotected and protect. This same type of code is successful with choosing trend lines and data labels on the chart object but not report filtering.

If anyone could help me with my original issue that would be great -

Here is an example of the code:

Please Login or Register  to view this content.

I am sure there is a better way to do this, but my limited experience constrains me. Basically, the user chooses functionality like add trend lines, report filters, adding data labels. All of the other code is similar to the code above.

Thanks again,

But no that's not correct - I already mentioned before that it is unprotecting/protecting. I have ran the code several times and it is indeed unprotecting and protecting the current worksheet. So again could someone offer maybe some better coding examples of how to unprotect - run report filter on a chart -then reprotect?