Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Filter pivot table results without filtering in SQL query27 Nov 2007 16:33 GMT1
I have a pivot table setup witht he results I need,however I need to only see
those results that are of a specific age (15 days of older, 30 days or older
etc).  Is there a way to filter my results so they show only that relevant
age data by a drop option, so I can always use the ...
Find and colour all cells with Validation27 Nov 2007 16:32 GMT1
Looking for VBA that will turn cells blue, if they have any validation rules
applied to it. Is this possible?
How?
I have something similar that makes all unlocked cells Yellow. It works like
Advanced filtering of Union of named Ranges27 Nov 2007 16:07 GMT1
First off, apologies if this has been discussed elsewhere. I've been
looking for two days w/o success. First, I'll describe what I'm trying
to acomplish, what I have done so far and what I came here to get help
on.
Lost My Personal Macro Workbook - Thanks Ron de Bruin!27 Nov 2007 16:04 GMT1
I posted the question below and received the solution from Ron de
Bruin.  This is an FYI in case anybody else experiences the same
problem.  I did not know the Disabled log was available and also found
a couple of Add-In DLL's that I had "lost."  So great piece of info.
Menu Restoration27 Nov 2007 16:02 GMT3
I have removed inbuilt Excel menus and replaced them with mine. Now if I
need to get back Excel to the default look I have restore the menus one by
one. Although it is a one minute task I like to know if it can be done with a
push of a button that is with with help of codes. If ...
Excel Question27 Nov 2007 15:41 GMT2
I have an excel spreadsheet containing the following sells that are in
questions. I would like to input a formula that will calculate the DOM (Days
on Market) based on
1. Status = Active (Y)
Email using Outlook27 Nov 2007 15:35 GMT1
I am currently producing a rather large spreadsheet on a daily basis, which
is automatically saved to sharepoint.  This is great, but I would also like
to generate an email which sends only a link to the file in the subject field
of the email, with perhaps a message in the body o ...
get from Excel 2003 add-in to Excel 2007 add-in27 Nov 2007 14:49 GMT5
All,
OK, I know I am having a mental block, but I cannot seem to transfer
my 2003 add-in to a 2007 add-in. I opened the AddIn.xls with Excel
2007 and saved it as a .xlsm. Then when I open the .xlsm and try to
Opening form in VBA. No error,code just breaks.Works on other PCs!27 Nov 2007 14:49 GMT1
Morning all!
((Im using 2003))
I have a button which is supposed to open a userform (which performs a data
scrape after users enter login info and hit enter.. )
Complete Excel VBA Reference27 Nov 2007 14:40 GMT3
I am looking for a Reference on Excel VBA.  One that has the complete list
and details on all Excel Objects-Properties-Methods etc.
Hide rows within a range IF...27 Nov 2007 14:31 GMT4
Newbie here so any help is appreciated.
Within the active worksheet, within the row range of Row 7 thru Row 1004, if
the value in Column CK for that Row is = 0, then hide the entire row.
hash value of range27 Nov 2007 14:08 GMT2
Simple question. Is it possible to make a hash value (is that the
correct phrase?!) of a range of cells in vba?
Suppose I had the following ranges:
range1:
How to get count summary of number that corolates with a name?27 Nov 2007 14:07 GMT2
I have a column that has multiple divisions (groups), and another column that
has the severity level for that particular item (could be 1,2,3).
Example
Group    Severity
Custom tooll bars in excel 200727 Nov 2007 13:31 GMT1
I have made custom tool bars with menus and macros attached in excel
2003
Having upgraded to Excel 2007, I can see the custom tool bars in the
addins tab but when I try to use them the path isn't recognised.
messagebox macro27 Nov 2007 13:26 GMT1
i have the following macro running off a button to call a messagebox before a
macro is run;
Sub Reconcile_Button()
'button to run "reconcile" macro, first runs dialogue box with YES/NO to
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.