Is it possible to have a progress bar that pops up on the screen on to
generate an equivalent using a worksheet/tab to inform the user that
the process is running and to be patient while a set of macros run in
the background? Thanks in advance

 All my sheets are being named, and since the names have a chance of
changing regularly, I've thought of storing them in constant variables
inside my Module1. I have many of my macro functions that I need to address
these sheets and their contents. Problem is VBA doesn't seems ...

Is it possible to prevent code in the Sheet Activate event from running
when another macro makes the sheet visible to perform another task?
I have code that copies the sheet when certain criteria is met on that
sheet when it is activated or made visible, however on occassion i need

I am using an Access db to populate an excel and a word document, print
them, and then close.  When it runs, the user should not be promted to
save changes when the documents close.  The code includes
"objWord.Documents("timesheet.doc").Close SaveChanges = False" and

Is it possible to "lock" the excel running a starttimer macro so no
other workbooks can be opened until the stoptimer is run?  I have a
starttimer that is to run for 4 hours every 5 minutes.  I have noticed
that if I get something through email it will open in that application

I have prob with my code that need your guide. I want to create a macro that
will generate numbers starting from 0 to 6 000 000 000 in Column A when user
click on the command button(Generate_Numbers). The numbers are in multiple of
50000. Below are the code: When I tried to debug ...

I'm having 4 sheets in a XLS named sheet1,2,3 and total.
I have 3 emploies and each one will complete an individual sheet, for
example emploie john will make a list with all of his clients in
sheet1, mark in sheet2,by columns etc.

I tried opening 50+ files using the Open method at theWorkbook class at one
go. However due to the size of each file, which average about 2 MB, the
process takes too long to open. Is there a more efficient way to open these
files? Because each file takes about 5 mins to process ...

I am in a desperate need of help. Can anyone let me know how to find
out a cell that contains a hyperlink. I mean we can figure out formula
by hasFormula function. How can we find for a hyperlink. Please help,
Nasir.

           When I close a excel file by click the cross on the left
top corner, excel will prompt me to save the file or not. I want the
excel not to save the file and not to  prompt me  to save. How can I
disable the save message when I press the cross to close the excel

I am working in excel and trying to access a Access workgroup database.
I have this piece of code and  I get an error “Records can not read; No
permissions on Table1” at this line:
    “   .Open Source:=Src, ActiveConnection:=conn”

To whom it may concern,
How do I include "Voting Buttons" in an Outlook email message using a macro
from Excel 2003?  I have tried adding them as objects within the email
portion of the macro code, but have not been successful.  Any help would be

I am creating an application which is addin to Excel. I am trying to dragdrop
a value from a form (which is Excel Addin Form) into selected Excel cells;
but the drag dropped value is being dropped to only one cell - but not to all
the selected cells.

I've tried adapting code to accomplish copy and pasting from the Sheet "All
Records" to a new Sheet called "Short Names"  all rows with 3 characters or
less in the last name of the Name Column which is column D in the All Records
Table.  The name format is last name, then a comma ...

When using this command
Workbooks.Open ("www.website.page")
A downloading box appear with a progress bar and a cancel button.
Is there a way to have the downloading progress box go away and put the