Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

WebArticlesForumsFAQs
JavaScript
ASP
ASP.NET
WCF

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

Operating SysArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Lounge
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 

  View Other Microsoft Excel Posts   Ask New Question  Ask New Question With Power Editor

Grouping In Excel
daniel robertson posted at Thursday, November 05, 2009 12:18 PM

I am curious if there is way to make my checkboxes invisible when I've grouped a number of cells with multiple (or even one set) checkboxes in that group.

So what I have is a group (i.e; rows 5-50) that have multiple Yes/No checkboxes in them and I want to group these cells which I have already done.  However, once I click on the minus sign to have them grouped, All of the checkboxes are still showing (all stacked on top of one another) on the grouping Header.

I believe myself to be lessened in excel with formulas and macros but I'm not very good at writing VBA codes so please be gentle with me...

 

Thanks

 

Daniel R

Reply    Reply Using Power Editor
  Rank Winnings Points
November 0 $0.00 0
October 0 $0.00 0
RE: Grouping In Excel
Gary Byrne provided a rated reply to daniel robertson on Sunday, November 08, 2009 10:23 PM

Hi Daniel,

It sounds like you are using checkboxes from the Forms toolbar in your cells, and then creating an Outline or Subtotals with those cells.  I think the problem is: those checkboxes are Objects, and Excel will not hide them when the cells are hidden (that's why you see them all stacked together).

To solve this the way you are doing it, I think it would take some moderately complex VBA code.  Instead of using checkboxes, you may want to consider using data validation in those cells, if possible.  That way, your users can still click in the cell to change the value, and you won't have the checkbox issue.

If you upload your file, I can take a look and suggest a solution...

Reply    Reply Using Power Editor
I come from a varied background of financial reporting and data analysis, having worked for many of the top mutual fund and investment companies in Boston before heading south for warmer climes. I've been a spreadsheet buff since the early days of using the DOS version of Lotus 1-2-3 in college (booted up from a nice big 5 1/4" floppy). Through the years I've gained a great deal of expertise with Excel, my weapon of choice, along with it's built-in automation companion VBA.
  Rank Winnings Points
November 14 $0.00 25
October 15 $0.00 44