Is it possible to restrict change access to an Excel document and still give
the ability to sort?
Thanks!
James

how to extend/increses the columns numbers after IV column, our requirements
is to add more columns for program to run from imported work sheet. need
sugesstion how to extend the columns in single work sheet

I have an excel file holding a number of macros that I would like to
be able to access whenever excel is open.  I have saved this file at C:
\Program Files\Microsoft Office\OFFICE11\xlstart. Now, when I open
excel, this file opens. However, I don't want the file to open, I just

I have every time the same error on the same  instruction, the
instruction is in a module and the error is Run time error 1004
Application-defined or objet defined error
The fonction is :

I have 2 macros which I would like to combine into one. Basically I would
like the user to start the macro (push a button) and a window/balloon or
something will pop up with the choice of option 1 or option 2. Choosing
option 1 will run macro 1 and choosing option 2 will run ...

I need to write a formula that calculates quarter for dates i.e.
if cell D3 >12/31/2006 and <4/1/2007 then "Q1" and so on till Q4.

I need to write a formula that calculates quarter for dates i.e.
if cell D3 >12/31/2006 and <4/1/2007 then "Q1" and so on till Q4.

Using Office 2003 and Windows XP;
I have a form that has some locked cells and some unlocked.
I want to protect the file or sheet (which ever level is right) so that
users can paste special - values into an unlocked area of the sheet (i.e. not

How do I pass an array to a sub routine?
Dim HeaderArray(1 to 6) as long
HeaderArray(1) = 43
HeaderArray(2) = 90

I seem to be missing something.  I see examples where a variable is used to
define an array.  When I try it (below) I get a message it has to be a
constant.  I would appreciate the guidance.  I obviously don't understand
something.

Scenario:
IF a cell in column D, contains *any* number within *any* text, then
convert *each* number to a hyperlink.
In my spreadsheet I have:

Is it possible to write some code to disable condtional formatting and then
later to on re-enable conditional formatting.>?

Dear friends
I used ' Office12\EXCEL.EXE ' as type library fo connecting to the
excel automation .
But this type library dose not support properties and methodes which

Is it possible to have a button float, and move as the sheet scrolls
down or up?
I use a long sheet and use a button with a macro and would like it
close to the cursor.

I need to check for drive "U:\" and if it does not exist then it will be in
drive "C:\".
the path will be the value of a cell, I have it as
MyCSJ = Range("csj")