Log In
Register
Home
Active Member
June 12, 2020
Offline
Hello,
I'm trying to figure out a way to toggle the highlighted squares on and off. I have a macro that I saw online but it's not working. I've attached the file that I'm working on.
Can you see if the Macro that i'm using is wrong some how?
Thank you in advance.
Wans
July 16, 2010
Offline
Hi Wansley,
Welcome to our forum!
You haven't attached your file or code, so I can't check it. However, if you want to toggle highlighting of cells on/off, you can use Conditional Formatting for this as explained here.
Mynda
Active Member
June 12, 2020
Offline
Hello Mynda,
Sorry about that. I've attached it now. Let me know if you see anything wrong with the code.
October 5, 2010
Offline
Hi Wansley,
You have code in the workbook which is not mine:
Private Sub Workbook_Open()
If GetCodeSetting("CodeSetting") = False Then Exit Sub
SetCodeSetting "CodeSetting", True
End Sub
The line in red is generating an error because it's expecting a Boolean (False or True) value but it's calling a Sub that returns a string.
If I comment out that line the code works as it should.
There are a number of Subs and Functions in the workbook that I am not familiar with (I did not write them) so I don't know if you intend for them to be used or not?
If you don't need them I can get rid of them and get the code working for you.
Regards
Phil
Active Member
June 12, 2020
Offline
Hello Phil,
I don't mind them being removed as long as i'm able to disable and enable the macro.
Thank you in advance.
Best,
Wans
1 Guest(s)
