Have a bit of a problem that i'm hoping someone here can help me solve.
Basically in a spreadsheet, i need the enter key to shift the selection to
the right for 3 columns when pressed, and then after the Third time i push
the enter key i want it to set the selection to the first ...

I've done this before but can't remember how.......
I want Excel to find all the cells on a worksheet / workbook and lock them,
to prevent users from editing the cells.  I know how to protect cells from
being edited, however, I can't remember the quick way to find all the cells

I have inherited a workbook from and employee that has left the company.  The
workbook has one of the worksheets password protected.  Is there a way to
remove the protection without knowing the password?

We have a excel template, which has the external data link. But I can't
change anything in the template file. Though I can do changes on the xls
file. Please help me to get the exact reason behind it. The xlt is not
protected from being edited.

I often show the difference between relative percentages and would like to
have a positive number show up as +9%.  Currently I only have -9% and 9%.  
Any help would be appreciated.

=IF(NOT(G2=G3), "No Duplicate")
I am using the above formula with a huge list.  I have false on one of the
duplicates but would like to have false on both duplicates as I want to sort
all the false ascending to remove them at one time.

I have a report that I reference definitions from a different worksheet
within the report.  On the definition sheet, I have the word being defined in
bold and the actual definition non-bold.  However when I reference it from
another worksheet excel only allows me to have it all ...

Hi, I am trying to use Ron de Bruin's code "Change cells or range in all
workbooks in a folder" to open files in a directory on my C:\ drive.  
The variable "MyPath" is locating the directory but after the ReDim Preserve
command the variable "Fnum" is saying "Subscript out of ...

2003
The following commands work fine:
ActiveWorkbook.Worksheets("STARS_UMD").PageSetup.Orientation = xlPortrait
ActiveWorkbook.Worksheets("STARS_UMD").PageSetup.Orientation = xlLandscape

I have a complex sheets. 4 separate sheets in fact. Each sheet has a data for
12 months by ( months) for four separate product. each month  there a macro
to copy data from these four separate sheet and compile into one. Your help
is much appreciated.

I have a collection of weekly data organised into rows. Where I have no data
for that week i simply enter "-". What I need is a formula to locate the
first number that occurs in a designated row.
For example if my data is:

Hi there
I am trying to return a number to a table of information that depends on the
values of two variables x and y.
The variables may take a number of different values (the table I need to

say >1400 & <1500 in a range from 1200 to 1600

Hello there, I want to set up a procedure to insert somes names into a
workbook that refer to another workbook (because the formulas in Excel get
WAY too long otherwise) and am using the following code (which of course does
not work):

How can i lock the cells with formulas so that no one can edit that cell
either by writing in that cell or by any other means. Some people write in
the cells with formulas and after that formulas disappear and only their text
remains.Please help a.s.ap.