Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How can I auto-center checkboxes in cells

I have a list of checkboxs (made from the Forms toolbar)in a column, one
per cell.
When I change the row height the checkboxes remain at the top of the
cells. Is there any way to have them remain in the center?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 279
Default How can I auto-center checkboxes in cells

look in help "add an ActiveX control"

right click check box and
Properties: Review /reset the properties of the check box and / or
Format Control: format control move & size with cell

anyhow most of your controls for a spreadsheet check box are in those two
right click spots

"Danny" wrote:

I have a list of checkboxs (made from the Forms toolbar)in a column, one
per cell.
When I change the row height the checkboxes remain at the top of the
cells. Is there any way to have them remain in the center?



Reply
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
Center All Pictures in Excel Cells Finny[_2_] Excel Discussion (Misc queries) 1 May 28th 10 05:27 AM
Merge and Center and Center Accross Selection Bojingles03 New Users to Excel 3 March 17th 09 07:05 PM
Merging cells in the center of a worksheet nevermore627 Excel Worksheet Functions 1 July 20th 06 06:14 PM
How do I center a heading across cells? DC25 New Users to Excel 7 March 23rd 06 01:11 AM
Cells not formating (won't center) Woody13 Excel Discussion (Misc queries) 2 January 25th 06 12:33 AM


All times are GMT +1. The time now is 03:47 PM.

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"