I wanted to know what would be the VBA Code I could put behind a butto
to Print All Worksheets in a workbook EXCEPT for the sheet name
MainForm?
Thank

I'm trying to compare the displayed value of two formatted cells.  The
idea is to detect the equality between 1.2345 and 1.23 when the format
is "#.##" without resorting to VBA.  This is Excel 2000, SP3.
So I decided that this might work (may be wrapped):

I am using data from one workbook and created drop down boxes i
another.  My question is - how do I get the drop down boxes to work i
I close the first workbook?  does the workbook always have to stay ope
for the data to appear in the drop down boxes

how do I unprotect a cell that is password protected if I do not know the
password?

Someone told me you can use Format/Conditional Formatting and selectin
the Formula is criteria to create a worksheet in which every other ro
is shaded. I can't seem to do it. Can anyone help
--

I am trying to import a CSV text file into excel in a column format vic
row due to the fact that I have 1024 cells of data and in the ro
format it gets cut off due to length limitations.  Anyone have an
ideas?  Thank yo

Hi everybody, I hope someone can help me.
I have a spreadsheet with 100+ rows of this type of
information. I want to be able to sort by any of the
column types, but the rows need to keep their integrity.

I see how to make a single cell into a Hyperlink but what if we want to have
all email and web addresses in a spreadsheet turn into hyperlinks?  Is there
an easy way to turn this on and off?

I always receive lists of lengths in inches for steel fabrication and in
order to enter this info into my metal fabrication program I have to convert
it to feet and inches. For example 158 inches =
13 feet 2 inches. I can receive hundreds of these daily. Is there a way

I've got several users in a subnet who are experiencing an intermittent
problem when saving Excel files.  They get an error message:
Your changes could not be saved to '...', but were saved to a temporary
document named '...'.  Close the existing document, then open the temporary

I am trying to use Excell as a itemized list for a
contract how do you get the printer to print with the
rows & columns like it apears on the screen? Also is
there a book or program that teaches this program?

Using Excel 2003 and the Format Phone Numbers does not work.  I have some
phone numbers as xxx-xxx-xxxx and others as (xxx) xxx-xxxx but can not get
them in all the same format.  Excel does not seem to be smart enough? It
takes one or the other, should we be able to select the ...

Say I have a spreadsheet with several columns and rows of data.  Say
column G is a column that I enter a date when a "case" is closed.  Can I
format the cell so that when a date is entered into column G12, for
example, the entire contents of row 12 turns another color, such as

anyone like writing macros? or know where i could findout how to write one
for this?
im after one that will do the following, with a button;
Sheet name = Totals

I have a spread sheet setup to display values from lots of other sheets
within the same workbook. only 77 cells require a user to input data, so I
have set up protection so only these cells can be changed when protect sheet
is enabled.