How can I disable Excel's Autosave programaticaly?  With code that I can put
in the spreadsheet whenever it is opened?  I don't want to have to turn it
off via Excel as this is too much of a problem for the 10 users that touch
the spreadsheet.  We are running Excel on several ...

i am working on a userform using vb editor.  i would like to have the
users print and save the form. i need a code to accomplish both.
thanks

I want to change the exemple of Ron: the last row of every sheet is to copy
in the summary sheet, not a static range.
I don`t know
where to add the Function LastRowDatenblatt

I have merged cells C1 and D1, and named it 'mergedCells'.
But I get a "400" error from the following VBA code:
[mergedCells].ClearContents
That seems odd. Is there a workaround?

First I am not use to doing this kind of stuff in excel so I apologize if
this seems like a sillly question.
So let's say in cells A200 - A226 I have the Alphabet, and in cells B200 -
B226 I have the numbers 1 -26.  

Hey guys, I need you help, creating a check digit.
I have a number: 012Q
Base sequence:
0123456789BCDFGHJKLMNPQRSTVWXYZ

Just wondering, is there a way a userform could show a cell range, such as a
sudoku grid?  I wrote a program that helps people solve sudoku, but the grid
I use is on the actual workbook sheets.  Is there a way I could have this
matrix (all the cells) appear as a window on a user ...

I have created a spread sheet and in this spread sheet I have an argument
that if a true statement is made certain cells turn Red.
I forgot how I created this,,, I know I came here to get the answere but Its
been to long.  and i cannot find where this takes place. It does not show ...

I attached the following code attached to a Command Button.  The purpose is
to ask the user for the unprotect password and if the password is correct, to
unhide cells and unprotect the sheet.  My only problem is that this asks the
user for the password twice.  I felt it was ...

I have a 2D array which I am attempting to sort.  The print-out below shows
the data in its original form and then what it looks like after the sort.  I
am trying to sort based on the 5th column.  But as you can see, the sorted
range suffers from 2 errors.  Firstly, the first ...

In my registration form I've a textbox for writing the quantity.
The corresponding controlsource cell in the spreadsheet where my figures are
collected, is set to "General Number" format. The reason is that the quantity
sometimes can be without or with 1, 2 or 3 decimals.

Hi , I'm using the application.filesearch method in an Excel macro to
identify a list of Word and  Excel files.  I want to check the read-only and
password protection attributes of these word & Excel files and return a flag
to a populated list in Excel.

I have a form with a text box in it (inserted where i
cut out some cells). When I get to the last line in the box, how do I get it
to make a "page 2", where the text continues at the top of the text box on
the second page? I need the Second page to be a copy of the first, but ...

I will be grateful for any ideas any one has on the following.
I have a long macro that when run sometimes calls the message box as below
and sometimes does not.  I have tried including it in the macro code and also
tried calling it (ie having it separate) and the only way i can ...

I have a sheet that was designed in high-screen resolution.   I am trying to
make it more friendly to my users that need the larger text on their screen.  
I have accomplished this by shortening one of the long fields then zooming to
fit the screen.  As well as letting that ...