Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disappearing formats in UserForms
I've created a cookbook, (Excel 2003 on my laptop running Vista), and have
15 userforms. On each Userform I have various numbers of OptionClick controls. The controls have a white background with black text. I have an autoopen macro that executes when the cookbook is opened. Everything works as it should. I copied the file to a flash drive and put it on my desktop, (also running excel 2003 with XP). When I opened it the main user form was okay but on the other userforms the optionclick buttons had a black background so you couldn't see the text. Everything worked but I had to go in and change all the backgrounds back to white. This also happened when I sent this file to a friend. Now when I update the recipes and copy the file to my desktop it does it again..Any Ideas? I'm stumped!!! Thank You in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disappearing formats in UserForms
I am not sure what you mean by OptionClick Controls, but background and
foreground properties can be set in the initialize event of the form for controls that have captions, such as buttons, of for any control property for that matter. If you are not certain what is causing the setting to change, just set it each time the form opens. "Andre" wrote: I've created a cookbook, (Excel 2003 on my laptop running Vista), and have 15 userforms. On each Userform I have various numbers of OptionClick controls. The controls have a white background with black text. I have an autoopen macro that executes when the cookbook is opened. Everything works as it should. I copied the file to a flash drive and put it on my desktop, (also running excel 2003 with XP). When I opened it the main user form was okay but on the other userforms the optionclick buttons had a black background so you couldn't see the text. Everything worked but I had to go in and change all the backgrounds back to white. This also happened when I sent this file to a friend. Now when I update the recipes and copy the file to my desktop it does it again..Any Ideas? I'm stumped!!! Thank You in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formats, how to scroll and view all formats? | Excel Worksheet Functions | |||
Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
Date and Time Formats in UserForms | Excel Programming | |||
Formats: Too many different cell formats error message | Excel Programming |