-
CommandButton Back Colour is not set on WorkBook Open
Hi All,
I am new to this forum so please accept my apologies if this has been asked before. In my workbook open process I have a line of VBA code to set the backcolour of one of my worksheet command buttons to indicate that it is active (to distinguish it from the other buttons). The code is invoked but the button colour is not altered. However, if I then click on the same button the exact same code is invoked to set the backcolour and the colour of the button changes straightaway i.e. as soon as the code is executed.
The only thing I can surmise is that the button colour has not changed during "start up" because the button has not actually been physically clicked. ?
Thanks Craig
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules