In my workbook, the user right clicks on the "List" sheet, a form is
displayed, and some code is run.  I disable the right click menu with the
following code:
Sub Workbook_SheetActivate(ByVal Sh As Object)

I am trying to take data from an excel database (HR Database) and create a
phone list by department in an existing worksheet (By First Name). I have to
use the Dept name as the header for each section followed by each person's
name combined as First&Last in column A followed by ...

Is there a way, to have a sheet, which the (end) user cannot see at
all?
I was thinking of something like OnAllowChange, like in Delphi, to
block users from even seeing a sheet(3) on my doc, unless they have a

I need the following to code to loop, but each time pasting one row further
down on Sheet 2 until the Control Find function finds "Ele NonRec END".
   Cells.Find(What:="ele nonrec", After:=ActiveCell, LookIn:=xlFormulas, _
       LookAt:=xlPart, SearchOrder:=xlByRows, ...

i was applied a simple formula to the first row and when i drag the
same formula down it doest work or the same answer repeats all the
time.
thanks in advance

I would really appreciate anyone who could show me macro code to accomplish
this.
I need to save workbooks with a filename generated from the values in
multiple cells. I need to fully automate this process up to the point where i

I have generated some VBA code using macros as my seed code. Below is what I
have. My problem is that it gives me 'N/A' after the last row of data. This
is a dynamic spreadsheet in that it adds and deletes rows each time it's
published. Once published I would like to run this ...

I am trying to create a macro that will create a report from the current open
file.  i want it to create a new workbook and save it as the contents of a
cell in the current workbook.  Here is the very rough beginings of the macro,
but i dont know how to get it to do what i want.

I want to be able to open a new workbook (which I can do) then save it as
workbook name + (value in B1 on open workbook, which will be a date).xls
How do I do this.  I can open the workbook and name it and save it, but I
want to be able to add the date in B1 to the name.

Using some great code from the "Contextures" website, I'm able to choose
multiple items from a drop-down list, then have them all appear in the same
cell  (separated by commas. )    E.g., 4 items might be selected, and all
appear in cell G8:

I would like my macro to check the name of the computer before running.
How can I retrieve the computer name value through a macro?
Thank you.
Eric

I have a workbook that contains 6 sheets.  I managed to create the
code to copy those sheets onto one worksheet.  Now I want to add a
column to the new worksheet that lists the worksheet name for each row
that was copied from a particular worksheet.  (That way, it will be

I've been using VBA with Excel since 1995, and have been plagued with a
seemingly random error in every edition I've used. My programs always utilize
forms for entering, manipulating, and reporting data. The actual spreadsheets
are either hidden or minimized. On occasion, I would ...

The user wants to find a record on a list. He enters a PO#, and it
searches the list.
Example. User enters in M123456.
The list contains this number, but also has M123456A, M123456B and

I have the following data and I am trying to make a loop to delete all row
except the ones that have the words 'Count Required' in column C
A    B    C                    D
UNIT    NAME    AUDIT              WITHIN?