Check Boxes
Hi Adam,
1: It is a macro correct? I manually run it when I am ready?
Yes.
2: I assume that I should place the check boxes
No. The macro adds a checkbox into each cell in the designated range.
, then run the macro (after adjusting it for sheet and range).
Yes.
3: Will it link the size of the check boxes to the size of the cell under
it?
Yes.
To see just what the macro does, open a new workbook, run the macro and
check the results. You can then close the workbook withot saving.
If you want to apply the macro to different ranges or sheets, you may wish
to change the line:
Set rng = SH.Range("A1:A100")
to:
Set rng = Selection.
In this case, manually select the required range(s) before running the
macro.
---
Regards,
Norman
"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
A couple of questions:
1: It is a macro correct? I manually run it when I am ready?
2: I assume that I should place the check boxes, then run the macro
(after adjusting it for sheet and range). Correct? Then reedit it, and
run it for the next sheet, and so on....
3: Will it link the size of the check boxes to the size of the cell under
it? If not is there a way to do this so that they automatically resize
with their corresponding cells.?
|