I have created the Personal.xls worksheet to run macros everytime a Excel
document is openned.
The problem now is that the Procedure Workbook_BeforeClose don't run when I,
for example, exit Excel by clicking in the "red cross" (Windows XP).

Is it possible for me to have excel sum all the one letter codes into
individual cells and let me know the count?
Ie. (AAABBCDDDD) A=3, B=2, C=1, D=4
and have those sums placed in an individual cell for each?

Must a ws be active to do a sort?
I have a button on sheet1 that, among other things,  sorts data on sheet2,
before reactivating sheet1.  Everything works fine, but I'd just as soon not
show the data on sheet 2 during the sort.

Hi Folks, Hoping I could get some guidance with this:
I have 3 columns of data on sheet1.
Column A is numerical "APN"
Column B is text "Product Description"

i have the following 2 problems:
first
i want to print a spreadsheet, but i want to create a function that
hides all the rows were the cells in the first column are equal to

Below is code that I found on a site by Ron De Bruin. It seems to wor
well for what I am asking it to, but I am curious if there is a way t
speed it up. The folder that it is pulling information from has severa
hundred files and it takes a great deal of time. I'm not sure if perhap

I have three sheets Sheet1, 2 & 3. I want to create a script that wil
password protect sheets 2 & 3 only.
Any help will be greatly appreciated.
Nick

How can I Clear range of cells (e.g. a1,,a10) using a command button on a
worksheet??? I want to use VBA.

I have two worksheets with partially same data. I need to copy only the
new rows from worksheet1 to worksheet2.
Worksheet1 is updated automatically every month (and thereb
overwriting previous months data) and worksheet2 has additional dat

I've got a list of 37 condition statements which i've combined into a
valdiated drop down list, but I need the cell adjacent to the list to dispaly
one of 37 unique colour a pattern combinations to allow mutiple selections on
the sheet to be easily read to assess commonality. Any ...

Hi All
New to the world of programming on an excel worksheet. I am trying to set up
an array that contains checkboxes, basically I have checkboxes on a worksheet
on three different rows and I want to scroll through the rows and use the row

I have the following code:
Code
-------------------
 Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Hello...
I have a quick, and probably insanely easy question regarding the
calculation of NETWORKDAYS.  I cannot get the following formula to
return a "0" value:

I need to be able to copy all sheets that are visible (could be 2 sheets to 5
sheets) to a new workbook and give the user the ability to save the file
before closing it.  I currently have code to extract one sheet at a time...
but I can't figure out how to put all of them into ...

I have the letters A - O in rows 1 - 15 of column A on my Excel
spreadsheet.  However, instead of the following routine making
subfolders under C:\RESERVES I get the error "file already exists".
Can someone help?