I have a cell (B1) that is this:
=IF(A1=1,"You may continue:"," ")
I have a textbox on a userform with the control source to this cell B1, when
I open the form, it shows "You may continue" in the text box, but when the

I want to know if the below if possible.
When copyng multiple cell ranges from one sheet/book to another. is it
possible to copy more than more cell range at a time from the primary
to the secondary ??

How can I take an action (Example: Display a measssge box ), if the user
clicks Cancel in the Open Dialog.
I got this API to work, but I know very little about how to manipulate it.
Some sample code and an indication of where to place ithe code would be very

i am doing some calculations using Macros. I have problem with check boxes. I
want to link with some cells so that i can put my input parameters there for
futher calculation. when i checked the box, link cells must appear and
viceversa.

I need to have code find and open the newest file. Here is what i have now
but it will just select any file with this name. I need it to find the newest
file with this neam.                                  
FileName = Dir("Q:\FTP\as400\exports\production\inv" & Inv & "\" & Inv &

Right now i have it so the user can browser for the folder they want then
select a file. I want to change this to going to
Q:\FTP\as400\exports\production\  
then select the folder and file.

sorry for probably a mundane question but i am only just starting to get my
head around vba in excel.
Is there a way for me to click on a cell which will open print and close a
seperate workbook. The workbook i would need to print is only 1 page so i

Earlier I posted a message about this, but thought the problem had to do
with a timer loop.  When the suggestions for fixes didn't help, I (after
about 3 hours of changing things around) discovered the following.
First the code:  (The button just clicked and previous button ...

I made a calendar file on Excel at a computer with Windows XP and a version
of Excel earlier than the 2007 version designed for use with windows vista.  
When I transferred the file to my home computer which uses these later
Microsoft applications (Vista and Office 2007), a user ...

I want to image to pop up when you mouse over cell as comment do. I know of
way to changing coment background to image, but it takes one second of
holding mouse over cell i need it to appear as soon you move cursor across
cell.

How can I detect whether a sheet is in page break preview?
Thanks!
Cliff Edwards

OK. I am sure somewhere the answer to this question is on this site, but I
can't find it anywhere.
 What I am trying to do is this: When the user opens the file and presses
the Log In button. I want the UserForm to check and see if there is a passord

Existing I have file A & B.  
File A is the summary (pivot table summary from other sources)
File B is the invoices master to store all invoice information.
What I hope to obtain is to generate file C (listed below).

Hope everyone is keeping well. :-)
I'm looking to incorporate code into my auto-open macro so that the error
message shown here does not appear
[URL=http://img142.imageshack.us/my.php?image=excellinksqu9.jpg][IMG]http://img142.im
ageshack.us/img142/8628/excellinksqu9.th ...

I'm writing some vba for a sheet which makes extensive use of named
ranges. For one reason or another, I want to copy over some _more_
named ranges from another workbook (i.e. their position and names).
I've got the following setup: