View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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