I have this code located under  ThisWorkbook to intercept a print request,
and run my code to print multiple copies. Now I know most of you will say
"why not just set the #of copies" well the problem is when I do that our
Color Laser will print lines in the merged cells where the ...

Problem statement-
I am trying to determine how to set the print area for my worksheet? I
also need to determine if it should be formatted as landscape or
portrait?  My problem is that some of my cells in the right-most

I am 'attempting' to calculate our phone line utilization at work. The
end goal is to determine how many lines we actually use at any given
point. I thought this would be an easy problem, however the more I
work on solving it, the more difficult it becomes.

I have custom toolbars in XL XP that I need to replace in 2007.
1) I need step-by-step examples how to alter the ribbon in Office 2007 for
Excel that changes only the current workbook and/or all workbooks;
2) Can changes made in my question 1 above be done using VBA or can it ...

I have created the following macro, which is supposed to save the file based
on values in specific cells and then exit Excel, but it needs to be modified
to not save the file if the users clicks on the cancel button in the SaveAs
dialog box.  I am a novice when it comes to this ...

I like to hide my micros and lock them down so you can not change them.

hi,
i have the following:
dim z as integer
for z = 8 to 100

I need help creating a formula! I have to keep track of my time and it goes
by minutes. If there is no activity after 7 minutes, the system assumes I've
taken a break. From the system I'm able to copy my time and paste it into an
excel sheet.

How can I do it?
Trying to Copy excel text on a range and paste special (text only) to Word
the same but pasting into the notepad
Thanks

JGLWhiz or anyone else.....
I am running the following macro and it is stopping on Set a.  I don't know
what is going on may be you all can help/
With Worksheets

When I type a associate number the in cell C7 another sheet retrieve all
info and I print this info. I have many associate number and I do not want to
type one by one and print one by one.
I need a macro to do all numbers at once.

I just found the microsoft solution to importing greater than 255 columns
into a workbook. This really works great. Unfortunately it only goes to
around 510 columns.  (http://support.microsoft.com/kb/272729)  In my case, I
need 2548 columns and 2548 rows. Obviously the rows are ...

I have a macro that imports data into a workbook.   The macro provides the
user with an option to either 'replace' the existing data with the new, or
'append' the new data to the bottom of the existing data.  I have a message
box that provides yes/no/cancel buttons, but ideally I ...

I need to create a macro that calculates a value based on several values in
a range. The result from the calculations shuld be copied into a new column
with the same range. I have tried to record this operation but I need help to
make the macro repeat the operations throug the ...

How would I make a textbox a required field for the user to enter information?
Thanks
Linda