How to handle other workbook events through personal.xls workbook

I

ivarsb

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top