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: 23
Default setting properties for shapes

Excel 97...

I have 4 option-buttons on a worksheet. My code makes a
copy of the worksheet. Now I have 8 option-buttons (4 on
each worksheet). The 4 buttons on the new worksheet are
by default grouped with the 4 button on the old worksheet,
but I would like each worksheet's set of 4 to be grouped
only with each-other (NOT all 8). Can I change the
GroupName property for the option-buttons via code?

Note that I added the 4 option buttons from the Control
Toolbox Toolbar.

If I add the option-buttons from the Forms Toolbar the
buttons seem to be grouped based on the worksheet. This
appears to be a solution, but I would like to know if
there is a way to make it work with the option-buttons
from the Control Toolbox.

I have noticed in the past that strange things haapen when
I put Option-Buttons or Checkboxes directly on a
worksheet. Sometimes when I print from different
printers, they seem to move around. Does anyone have any
input on this?

TIA...
 
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
Setting the default properties for cells in all new spreadsheets Bon Bon Excel Discussion (Misc queries) 1 March 20th 10 01:01 PM
Setting custome RGB properties to specific cells kippers Excel Discussion (Misc queries) 2 May 9th 07 09:07 PM
Setting format properties when opening Worksheet Don Excel Worksheet Functions 1 December 12th 06 10:27 AM
Setting properties for Embeded Excel in HTML excelnewbieian Excel Discussion (Misc queries) 0 August 11th 06 04:16 PM
Setting Tab Properties in Excel beldarski Excel Discussion (Misc queries) 2 October 28th 05 06:10 AM


All times are GMT +1. The time now is 07:06 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"