Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tankthefrank

    Xml Report being output to Excel (Number field outputting as General)

    Hi, I have a field in my xml template with the following properties: type: number number format: #,##0.00 when i view my template in excel (2003), the field is displayed as "general" instead of "number". because of this, i can't do calculations for this field, until i change the format from...
  2. tankthefrank

    Excel: group (expand/collapse rows) event trigger (to unhide a colum)

    Hi folks, Hope all is well! I simply want to add in some vba to unhide column D whenever "any" of the group row expand buttons on the worksheet are selected. Then re-hide Col D when "any" collapse button is selected. It is prob a simple one for you wizards but it would really help me. Cheers
  3. tankthefrank

    Excel: group (expand/collapse rows) event trigger (to unhide a colum)

    Hi folks, Hope all is well! I simply want to add in some vba to unhide column D whenever "any" of the group row expand buttons on the worksheet are selected. Then re-hide Col D when "any" collapse button is selected. It is prob a simple one for you wizards but it would really help me. Cheers
  4. tankthefrank

    Expanding rows by double clicking certain cells

    Hi, I have attached a test s/s to demo what i'm trying to do. I want to be able to double click a cell (underlined cell in col D) to expand out grouped rows. So basically i can have a finer list of rows which can be expanded out individually by double clicking any of these underlined cell...
  5. tankthefrank

    Excel: collapsing/expanding rows by double clicking cell

    hi folks, I'm pretty retarded when it comes to excel which after 10 yrs of using is pretty poor. Objective: create a cascading look across a s/s. I want the user of the s/s to double click on a cell (NOT THE COLLAPSE/EXPAND button in groupings) to expand additional rows, and vice versa...

Part and Inventory Search

Back
Top