I have a template that I do not want it to be saved under any
circumstances when any part of it is modified. I have been able to
program the X button not to save with:
Private Sub Workbook_BeforeClose(Cancel As Boolean)

I have a workbook with 2 sheets:  Summary and Template.  On the Summary
sheet is a list of people in a range called emplist.  the macro below
copies the tempate worksheet and renames it to each of the employees
listed in emplist.  The problem is that is always fails after adding

I have a question..
In visual basic6.0, instead of having lot of commnad buttons in a form,
they can be included in menus using menu editor.. Is it possible to do
so in VBA?

to position a user form rightmost on the monitor
I miss a preset constant for the property
StartUpPosition aside of 'manual', 'centerowner',
'centerscreen' and 'windows default'.

Hide Macro's
Is there a possibility to hide created macros within macro window from
the users?  This is to prevent users to execute out of sequence code.
Ardy

Hi, I've been thinking how to do this, but I'm not quite advanced
enough to crack it yet.
I'd like to create a macro that saves the user identity (preferrably
system logon ID, but User name from Options would suffice), and date

I want to use Application.CalculateFull to calculate all the formula on
my spreadsheet. I have some data pulling from Bloomberg so it may takes
some time for the calculations to be completed. Is there a way to know
when the calculations are done? Cause once they are, I want to ...

I need to make the following procedure dynamic. Also there are blank
cells in both column E and column F that need to be skipped over for
the procedure to finish its job. Help greatly appreciated. From a user
standpoint is it easier to activate this from a button?

Excel XP & Win XP
I'm helping an OP.  He has Excel 2003 Pro.
He and I have now run the code shown below several times on both our
computers.  His computer fails on the "Set wb = Workbooks.Open.........."

Need some help condensing this code...
I used some of that good old copy and paste from this group to make
these, but I wondered if I could condense them into one loop so that
I'm not looping the entire column 3 times.  It gets large and takes a

Hi everyone.  Is there a way for vba to run through all sheets in a
workbook, and set each sheet name to the value in cell B1 of that
sheet?  Thanks!

I have managed to write code to copy a specified range in a worksheet and
paste it into a Word doc.
I have used:
    Dim wdApp As Word.Application

i have to export Diagrams out of Excel 2003 during an automatic analysis,
and i have some trouble with it. If i use the standard way (in my
understanding) with VBA like this:
    Dim Dia As Chart

Hello Gents/Ladies...another question....
I have a cell, C13, that says:
Bonus: $4,000 (DEC06).
My question:

I have a workbook that has two worksheets in it.
Worksheet A contains a list of names and phone numbers.
Worksheet B is a form that contains some static information and a need for
some of the info from Worksheet A.