I am trying to restrict what the end user can do in my excel application. I
have disabled all; Built in Menus, the Toolbar List  and also the cell menu
bar, however on my custom menu bar there is still a drop down to add & remove
buttons. So the end user can still add buttons and ...

first post here, playing around in VBA, and I have the following
question.  Well, I'll first explain the situation:
Sheet2: Database with range of cells
Userform1: contains Textbox1 in which user can enter data to be added

I have 6 labels named lblMachine1, lblMachine2, lblMachine3,
lblMachine4, lblMachine5, and lblMachine6.
Is there a way to loop through all of these labels and populate all of
them with data? I have tried the following;

ActiveWorkbook.Names.Add Name:="Members", RefersToR1C1:="=Lists!R3C5:R12C5"
I have this in "Workbook_Open". But How do I expand the area if new members
are added

For some reason, I'm suddenly getting an error when opening a userform (any
userform).
When I click a command button, the userform form will briefly open, but then
close and the sub procedure "userform1.show" will be highlighted in yellow.

Hi...
I'm stuck. I'm after some code that will allow a macro button to do the
following...
1. reset all auto filters to standing position (all unfiltered)

I am changing a simple graph to a two-series graph where for each
row-iteration I have to change the series, for example to:.
I need two series that take data from the same row:

I have trawled the newsgroups for code to highlight the active row.
Below is the code that l am currently using which works fine until you
want to carry out copy / paste on the active worksheet.
Does anybody have the code that colours the active row AND allows copy

I created a protected worksheet in a shared workbook in order to allow the
users accessing only certain cells, but in macros I should like to change
some locked cells. Unfortunately XL2000 doesn't allow UnProtect method in  a
shared workbook.

In VBA, is there any way of removing the little X buttons off the dialog
boxes top right hand corner??

Using VBA...
1) How do I determine which operation system (98 or XP) is running on he
computer?
2) For the XP op sys, how do I determine which user is logged into the

I am having the hierarchial data in the excel in the following format..
----------------------------------------------------------------------------------------------------------------------
Column A                        Col B                  Col C
 Column D

I need to write/record a macro that takes multiple files(UNIX files)on
the local computer and then copy all their content back to a sheet of
the excel and then manipulate the data to generate a report. I
particularly need help with macros that can import multiple files. I

I need to write/record a macro that takes multiple files(UNIX files)on
the local computer and then copy all their content back to a sheet of
the excel and then manipulate the data to generate a report. I
particularly need help with macros that can import multiple files. I

I hav a macro which generates a work sheet and names it as sheet2,sheet3
etc. Then I use Vlookup to fill in some entries in the new sheet. Now I want
to send this sheet to 5 to 10 persons whose email addresses are contained in
Cell D8 to Dx in another sheet named "Main".