Toggle Button triggers sheet protection warning, despite using Unprotect in the macro

Hi everyone,

I have a macro that is hiding/showing certain rows, which is activated by a Toggle Button.
However, the sheet on which this is set is protected.

My problem is the following:

When clicking the button, Excel will show the "sheet is protected"-dialogue, you would also get when trying to manually enter data in a protected sheet, even though I use Sheet.Unprotect in the macro before anything is changed on the sheet.
Putting the Sheet.Unprotect as the first line in the Button_Click Event or using Application.DisplayAlerts also doesn't help.
Funnily enough, the macro still works. The sheet gets unprotected, the rows are hidden and the sheet is protected again, but as I said the dialogue always shows.
I don't really mind that, but since others are using the file and they don't know that everything is fine, when the warning shows, I would like to fix this.

Currently my code looks like this:

Please Login or Register  to view this content.

The sheet is unprotected in the called Sub before anything is changed on the sheet. But as mentioned, putting the unprotect line first in the Click event does not help either.

I would be happy to hear you guys' thought on this

Could you attach a desensitised copy of the file so we can see it in context? I suspect there is another piece of code being called prior to unlocking the sheet.

BSB

I tried to recreate the issue in a new workbook, however I did not get it to produce the same behaviour.

However, I have no idea, what could be the difference, as the code provided is the only code in the worksheet.
I guess it must be some other events that are triggered and registered by other workbookwide code maybe? Do you have any pointers, where I might look, maybe?

Originally Posted by _christoph

Do you have any pointers, where I might look, maybe?

Without seeing the file?? No.

BSB

If you look at the properties of the toggle button, it's linked to cell J6. So each time you click the button it's trying to change that cell between True and False and that's what throws up the warning.

Either make that cell unlocked then protect the sheet, or if you don't actually need the True/False value in that cell, simply unlink it from the toggle button.

BSB

Aaaaah, that makes so much sense. Thank you!

Happy to help

BSB