LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default Visibility Problem of Embedded Buttons in Worksheet

I'm not sure if you're experiencing a display problem or a problem in your
algorithm.

You may want to post your code to get a good response.

Anson wrote:

I am using the Excel 97 and have been trying to solve this problem for weeks. Wonder if anyone can help me on this:

I have embedded 5 command buttons, 3 combo boxes and 6 options buttons (3 groups) directly on one of the sheet in an Excel workbook. I have programmed it so that the combo boxes, options buttons and 2 of the command buttons to be invisible unless one button is clicked. When I click on another button (cancel), they should be invisible again. However, when I run the program, one combo box and 2 option butons are always visible and some command buttons are not visible when they should. I have checked the codes and also the grouping of the option buttons and they all make sense. I tried the same codes but replaced "Visible" with "Enabled" and they worked! Why can I enable and disable them but can't hide and unhide them? Are there anything I should be aware of when I set the visibility of the objects on the worksheets?


--

Dave Peterson

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel pivot tables - specific expand/collapse buttons visibility MichaƂ Lenartowicz Excel Discussion (Misc queries) 1 October 19th 09 09:48 AM
Limit Visibility of a worksheet Tdahlman Excel Discussion (Misc queries) 1 March 12th 08 04:13 PM
Excel VBA: Problem with copying an embedded chart from one worksheet to another Flystar[_13_] Excel Programming 2 May 21st 04 01:13 AM
Command Button Visibility Problem Ian[_9_] Excel Programming 2 February 20th 04 06:51 PM
Embedded option buttons Jerett Excel Programming 0 December 31st 03 04:04 PM


All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"