I want to create a "menu" page that will take you to separate worksheets in a
workbook.
I can't seem to link the macros to the buttons....  
I also want to send a worksheet to an e-mail recipient for approval, and

I was wondering if anyone can give me a hand.  I just created a button
that has code within it to open a new work book and rename some tabs.
The next thing i need to do is some how be able to popluated the excel
sheets with data from MS access queries into the correct tabs in

I'm wondering if anyone can help me out with the code below. When i
run it it takes very very long time to run. i would appreicate your
help. The data size is very large with multiple sheets but same
workbook (more than 50k rows and over 24 clos.)

How to Set Focus to the row - Option Button Click
***My Problem***
when you click on an Option Button it does not change the focus or make the
Option Button cell the active cell.

hi,
i would like to know if there is a way i can hide the code in a spreadsheet
after i pass it along. and will the code still work if it is hidden?
thanks in advance,

How do I add a button to hide/show a data series in my log or semi log chart.

i need a mocro to check if its the last day of the month and if so del
contents in cell a1
for example
chek if day = 31 then del range a1. if only 30 days in month then

I have been using the expression =SUMPRODUCT(--(file'!$P$1:$P
$65500="txt");'file'!$H$1:$H$65500)
to summarize all cells in column H where column P= "txt"
I have 1200 of theese expressions and it make the startup and

I need a formula that will give me the total number of weeks and days
between 2 dates.  ie.  b3=Apr-2,2001, c3=Oct.31,2001  what is the
total number of weeks and days between these dates.
I have the formula to get the number of weeks but have trouble getting

I am trying to create a prompt that will allow the user to select the
column by asking them to click which month they wish to update.... The
names of the month are in Row 1 starting at column B.   The
information for each month will be filled down each row for that

I am using the following code to populate a drop down on a FORM in Excel.
Public Sub PopulatePositions()
   Dim AllCells As Range, Cell As Range
   Dim item As Variant

I need to write a macro that copies cells in a specific row and then
loops to the next row, next row being 5 rows below.
So, copy cells C7, D7 to H7
then, Copy the next set C12, D12 ... H12

I have this code (Thank you Bob Phillips):
[code]
Sub LoopFolders()
Dim oFSO

I have a spreadsheet and am running so code across the sheet, all of a sudden
instead of applying the code it is now just putting the formulas in the
cells, I know a setting has changed somewhere but I can't find it
Any suggestions

I am using this code
Workbooks.Open Filename:="I:\Aging\Month End\CMT Monthly Aging 07.xls",
Password:="atervse"
But I am still prompted for the password.  I want the file to open with