Been replying to another thread and this code adds the checkboxes for you.
http://www.excelforum.com/showthread...93#post4503893
Simplified the code in the post above so you can add checkboxes to any selected range. You don't need to save the code in the workbook you have added the checkboxes to for them to work. A good place to save the code would be your Personal Macro Workbook.
https://support.office.com/en-us/art...rs=en-US&ad=US
You could then put a button in your Quick Launch tool bar to add checkboxes wherever you want.
Sub Addcheckboxes()
Dim c As Range
Dim cbo As CheckBox
Application.ScreenUpdating = False
For Each c In Selection
With c
Set cbo = ActiveSheet.CheckBoxes.Add(.Left, .Top, .Width, .Height)
cbo.Caption = ""
cbo.LinkedCell = .Address 'Links the checkbox to the cell it occupies
.NumberFormat = ";;;" ' Makes the font invisible, so TRUE FALSE isn't displayed
End With
Next c
Application.ScreenUpdating = True
End Sub
Bookmarks