I am using a TextBox as a back ground.  I have done this in a UserForm
to color a MultiPage control by setting the display order>Send to back
or Bring to front with ZOrder.  I don't see that command available for
a Control Toolbox Label.

I am trying to open a browser window from VBA and navigate to a
password-protected area but everything I have tried fails.
The navigate method fails with a url such as "http://
xxx:yyy@place.com", I cannot get sendkeys to work either and using

Below is the scenario which need to run the data sorting, subtotalling
and the result shows only the subtotal and grandtotal rows after
closing the side filter panel.
Is there any excel formula or VB code to copy only the subtotal cells

COL A has 2,374 cells whose contents look like this:
102050013
102050016
110103030

Re : Excel VBA-Chemistry Before and After ......
1. Enter an Excel worksheet and the VBA module thereof.
2. The VBA used to run OK ; and then, it began to behave as
follows ......

It seems I can only save to PDF one sheet at a time, is it possible to print
multiple sheets in a single PDF document i.e. multiple page PDF?
Thanks.

How to change font colour of userform Textboxes text,Lable captions,Userfrom
captions,Combobox list values,Command button captions ?

I am trying to make my excel sheet automatically give off the date and time
when some data is inputted into the cells next to it.  I managed to do this
with this code but wanted to add the security that the person signing off is
actually authentic.  I tried to insert your code ...

I have the following macro that is assigned to a button on the formatting bar.
Note:  The macro is in a different file than the file where the cells are
selected.
Sub SumSelectedCells()

I'm looking for a printable chart showing the structure of the VBA language
(for Excel use) basically to be pinned up at my desk. Can this be found on
the web?

How can I lock cells so that the info can't be changed. (So that they can't
even try if possible)
Also is there a way that if I have
A1 and E3

Can I format the comment in excel ?  More specifically can I change
the leader to make it thicker and have a bigger arrow ?

How can I use validation to stop users from entering the following
characters?:  / \ : * ? " < > |

I'm trying to write VBA using either Search or Find to determine if string A
exists in string B, and the debugger insists it doesn't recognize either,
although Help alleges they are available to VBA.  Anyone have an idea why the
error?  No missing references....   (Excel 2003 ...

  I'd like to create write a function behind a button that selects all the
jpg images embedded on the worksheet surface.  The command I found for this
is activesheet.Shapes.Range(Array(n1, n2, ...)).Select.  At least this is the
command which provides for one shot selection.  I ...