I want to create a UserForm which would work like this.


1. I turn UserModal to false in order to be able to click on cells
when the UserForm is showed.
2. When I check in Checkbox then all selected cells are changing style
or value depending which option I choose
3. Then I click on cells and they automatically without pressing any
button change style

Normally I would choose SelectionChange event from the workbook. But I
wanted to handle SelectionChange event from other workbook, which is
my personal workbook. How can I handle that without pasting code in
Worksheet page manually?

You would need to instantiate Application Level events in your personal.xls

see Chip Pearson's page on application level events

http://www.cpearson.com/excel/appevent.htm

--
Regards,
Tom Ogilvy



"ivarsb" wrote in message
om...
I want to create a UserForm which would work like this.


1. I turn UserModal to false in order to be able to click on cells
when the UserForm is showed.
2. When I check in Checkbox then all selected cells are changing style
or value depending which option I choose
3. Then I click on cells and they automatically without pressing any
button change style

Normally I would choose SelectionChange event from the workbook. But I
wanted to handle SelectionChange event from other workbook, which is
my personal workbook. How can I handle that without pasting code in
Worksheet page manually?