karognigni
09-01-2011, 07:49 AM
I'm running XP, SP3.
I'm running Xcel 2000 9.0.2812 (yeah i know, i know).
I'm trying to do this via VBA.
I would like to click on a Xcel file stored in my network.
I would like this files opens and automatically shows a Combobox filled with 10 choices, stored in the combobox, not referring to cells.
I would like to choose one of the choices and by consequence run a macro, without an action button to press.
In the end, 10 choices in combobox, 10 consequent macros, running as the choice is made.
The action of the macro should be to deactivate the sheet protection, apply a customized view, and reactivate the sheet protection.
I've tried thousands of ways, no solution.
Is this really impossible?
If no, can you send me a code and where to write it?
Many thanks.
Ale
I'm running Xcel 2000 9.0.2812 (yeah i know, i know).
I'm trying to do this via VBA.
I would like to click on a Xcel file stored in my network.
I would like this files opens and automatically shows a Combobox filled with 10 choices, stored in the combobox, not referring to cells.
I would like to choose one of the choices and by consequence run a macro, without an action button to press.
In the end, 10 choices in combobox, 10 consequent macros, running as the choice is made.
The action of the macro should be to deactivate the sheet protection, apply a customized view, and reactivate the sheet protection.
I've tried thousands of ways, no solution.
Is this really impossible?
If no, can you send me a code and where to write it?
Many thanks.
Ale