VBA Checkbox

[Hiport]

Hi, the below code removes the tick from checkbox when workbook opens, how can i add this to a module so i can call this from a module sub rather than Thisworkbook?

ThisWorkbook.Worksheets("Tasks").CheckBox1.Value = False

 

[jeffreybrown]

Honestly not sure why it won't work, but you gain a huge benefit over doing it the way shg offered.

By using the codename you will ensure your code always works without having to trap for some type of error.

What if a user change your sheet name from Tasks to something else?

Your code will fail, but with the codename you can ensure it will always work.

 

[Hiport]

Honestly not sure why it won't work, but you gain a huge benefit over doing it the way shg offered.

By using the codename you will ensure your code always works without having to trap for some type of error.

What if a user change your sheet name from Tasks to something else?

Your code will fail, but with the codename you can ensure it will always work.

Thats all good, my workbook is protected the user cant change anything.

I just find it bizzare why setting sheet does not accept it, i will try shg method.