We have a requirement such that it has become necessary to remove the default
"(All)" form the drop down pivot fields lists for one of the pivot tables.
If you really want to know why, we are creating a report in which "All" is
one of the fields in the dropdowns. And that "All" is ...

I have the user pick up a date from the calendar and returns that value to
the txt1stDistStart.
I wanted to validate that the date selected is less or equal  to the
Effective Date (txtEffdate) if not I wanted to return to the Distribution

friends,
I have an Access database (Customers) and an Excel template (Quote
Template).  I would like to open the Quote template , click a command button
within the workbook, and bring up a list of record (Customers) from the

background:
i am creating a function that is dependent on a few different
variables. temperature, physical component, weight percent.
problem:

guys:
I have the code below to copy and paste all vales for all workbooks in
the active worksheet.  for some reason it doesn't do it for all sheets
though.  is there anything wrong with the code and/or a better way to

I have a work book with multiple sheets. Some of the sheets have the
same person. I would like (and can't figure out how) to have it so
that when I update it on one page if automatically updates the other
sheets regardless of which sheet I update on.

I have a problem with my code. I have made a userform with a textbox
and am trying to filter a set of numbers in a column.
I can get it to work when I write the exact number in the textbox
which

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,Cancel As
Boolean)
Call SClassModule.SSave
End Sub

I want to create a macro or a procedure that will take a portion of a
worksheet and then send it to an email address.
This is to basically sending an invoice. I want to include this in the BODY
and NOT as an attachment.

This gives me a type mismatch in Excel 2007 but not in 2003
If Cells(MyRow, MyCol) = 0 Or IsEmpty(Cells(MyRow, MyCol)) Then
Does anyone know why?
Thanks.

I am using this formuala to hide columns: Columns("by:cc").Hidden = Not
Columns("by:cc").Hidden
What formula do I use to hide a row?
I am trying to do it for rows A3:A30, and get a syntax error.

I am using a Calendar Control on my spreadsheet to allow users to
select a date which is linked to a specfic cell. I used generic code
from Ron's website (http://www.rondebruin.nl/calendar.htm) to show and
use the calendar. However, I've run across a problem and was wondering

I have checked the site:
http://j-walk.com/ss/excel/tips/tip44.htm
but the difference with my problem is that I dont have a user form.  I
just have an excel sheet with some command buttons on it.  When you

If I have two columns like below.  How do I set something up, so that I can
input a Team Name, lets say Team2 for example and then under that team name I
get a list of every player on that team.   So for the example below I would
end up with.

I'm trying to save my users from themselves by forcing them down a path with
choices.  Specifically I've created a form that asks for a selection. The
selections will take them to the appropriate sheet to the next step. All my
sheets are hidden until necessary and so far it's ...