gemcgraw
Board Regular
- Joined
- Mar 11, 2011
- Messages
- 72
I am toggling command buttons (enable/disable) based on a variable's value from the same or another spread sheet. I believe I need to make those variables globle in order for the statement to correctly see it. I'm not sure if that is my issue or not and how I can effectively do that. I am including the "Dim" statement on the sheets involved as well as setting the "integer" value to 1 and/or 0. Ideas and comments appreciated.
i.e. If they click on the "Print" Command button, I toggle the PrintHistory interger to 1, if that is true, then the "Move History" command button integer is set to "1", else, it's set to "0" which disables the "Move History" command button.
i.e. If they click on the "Print" Command button, I toggle the PrintHistory interger to 1, if that is true, then the "Move History" command button integer is set to "1", else, it's set to "0" which disables the "Move History" command button.