How to handle other workbook events through personal.xls workbook
 

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?

How to handle other workbook events through personal.xls workbook
 

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?