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: 17
Default No control for option buttons, invisible macro??

I have a spreadsheet with what appear to be five option buttons on one
of the sheets. However, when I try to select them for editing format
control, etc. (not just click on them -- that works), I cannot do it.
Normally one can right-click on the button and get the menu with Format
Control, Assign Macro, etc., but not in this case. And if I select the
Select Objects arrow from the Drawing toolbar and try to select these
buttons, nothing. Also, when I click on one of them, a button appears
that when clicked obviously runs a macro (it unhides some sheets), but
this button too appears to be inaccessible to editing, etc. Finally, I
cannot see any of the macros assigned to these objects -- the one that
generates the button when one of the option buttons is clicked, nor the
one that unhides the sheets when the generated button is clicked. Any
help is greatly appreciated.

 
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
Using Multiple sets of Option Buttons (Form Control) In Excell Michael Hudston Excel Worksheet Functions 2 February 26th 09 08:07 AM
Worksheets and Control Option Buttons KHaydel Excel Worksheet Functions 1 April 9th 07 11:19 PM
How do I create a form in a worksheet with control option buttons. andreah New Users to Excel 2 April 23rd 05 01:12 AM
Selective control of Option Buttons gtcyberaz Excel Programming 0 February 25th 05 06:03 PM
Control Box Option Buttons jlarkin Excel Programming 4 April 23rd 04 12:31 AM


All times are GMT +1. The time now is 06:53 AM.

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

About Us

"It's about Microsoft Excel"