A
Alva Dean
I use visual basic code to check to see if a daily
spreadsheet has been created and saved. If it already
exists, the spreadsheet is opened and displayed. If the
daily spreadsheet has not been saved a template is loaded,
date and day of week are entered, and then the spreadsheet
is saved with the current day in the file name. The excel
application and the workbook are made visible and a
combobox is populated from data on worksheet(2) of the
workbook.
All this works fine. There are six command buttons on
worksheet1 that reset their backcolor when they are used
so I can tell visually when they have been used and what
meal is represented by the data in a given column.
PROBLEM --- The BACKGROUND COLOR OF THE COMMAND BUTTON
FACES RESET TO THE DEFAULT COLOR (&H8000000F&) when the
worksheet is loaded by this routine. They may initially
display with the correct colors, and change to default
color after a command button is used. I think I have seen
them cange to the default color when nothing is going on.
The command button properties box for backcolor shows the
correct color value, and the button face still shows the
system default color. If the spreadsheet is loaded from
the desktop or file open options, ther is no backcolor
changes.
spreadsheet has been created and saved. If it already
exists, the spreadsheet is opened and displayed. If the
daily spreadsheet has not been saved a template is loaded,
date and day of week are entered, and then the spreadsheet
is saved with the current day in the file name. The excel
application and the workbook are made visible and a
combobox is populated from data on worksheet(2) of the
workbook.
All this works fine. There are six command buttons on
worksheet1 that reset their backcolor when they are used
so I can tell visually when they have been used and what
meal is represented by the data in a given column.
PROBLEM --- The BACKGROUND COLOR OF THE COMMAND BUTTON
FACES RESET TO THE DEFAULT COLOR (&H8000000F&) when the
worksheet is loaded by this routine. They may initially
display with the correct colors, and change to default
color after a command button is used. I think I have seen
them cange to the default color when nothing is going on.
The command button properties box for backcolor shows the
correct color value, and the button face still shows the
system default color. If the spreadsheet is loaded from
the desktop or file open options, ther is no backcolor
changes.