Toggle tool tips

[dpaton05]

I have a button to toggle tool tips in my spreadsheet which are data validation input messages. The button reverses their current state, so if they are off, they will get turned on and vice versa. They used to work and I have no idea why they have stopped working.

The button only calls this sub

Sub ToggleTips()
Quoting.Unprotect Password:=ToUnlock
    Dim st As Range, cell As Range
        For Each st In ActiveSheet.UsedRange
            If HasValidation(st) Then
                st.Validation.ShowInput = Not st.Validation.ShowInput
            End If
        Next st
Quoting.Protect Password:=ToUnlock
End Sub

When I click my button now, I get an application defined or object defined error. The following line of code is highlighted.

st.Validation.ShowInput = Not st.Validation.ShowInput

Can someone help me please?

 

[dpaton05]

Don't worry, I worked it out.

 

[Peter_SSs]

Glad to hear you got the solution.

Do you mind posting about your solution? Then it is perfectly fine to mark your post as the solution to help future readers.

 

[dpaton05]

Sorry Peter, but I didn't think that my solution would be of any use. I keep different versions of the file I am working on and as it was almost the first thing I did when I arrived at work, I tried reverting to the previous version and that got rid of the error. Not sure what I did to initially cause the error.

 

[Peter_SSs]

OK, but note for the future that 'Mark as solution' mark at the right of posts is for the solution post, not just that you have solved it and don't need any more help. You had marked post #2 as the solution when clearly it does not contain the solution to your question so I removed that mark.

 

[dpaton05]

Alright. I am sorry I marked it as a solution. In future if that happens, I will not mark it. I just thought that i needed to let people know that a solution wasn't needed for that post.

 

[Michael M]

@dpaton05
If the code worked on another version and not the current one....there must be some differences either in the code / s OR the process in the worksheets.
Have you tried copying the Non Working code to the version that does work and see if it works there, that would then eliminate the error being / not being in the code.

 

[dpaton05]

I could try that next time it happens but I copied over the file that wouldn't work and I have no idea what I did in the first place to cause the error.

 

[Peter_SSs]

In future if that happens, I will not mark it.

Great, thanks.

I just thought that i needed to let people know that a solution wasn't needed for that post.

You did that already by what you wrote in post #2 and that is all that is needed for that purpose.