is it possible to remove the caption and border from a user form ?

I have a workbook designed in Excel2000, where visibility of some seets is
controlled by Change event of SetUp sheet. In Excel2000 it works OK, but
when I open the file in Excel2007 (it's first time I have used any version
of Excel higher than 2000 so long), then there are no ...

I want to develop a spellchecker in excel.I want that excel
spellchecker should work similar to the word auto-spell checking. i.e
all spell mistakes start appearing in red.
How can i implement the same ? Any pointers ?.

I hope this can be done.
There are 84 'budget' cells with formulas based on totals in 'other'
cells from other worksheets.  There are 84 similar 'actual' cells
based on the same identical 'other' cells.

Please see the table below
    A      B      C
1   31    34     23
2   22    27     45

I created a file which is going to be used by many people that uses SOLVER
-- I put in code that I obtained from a site (Jon Peltier's site) that
automatically installs SOLVER every time the file is opened (the code is
within a module that is called in the Private Sub ...

Hi there...
ThisWorkbook.Sheets represents the workbook that has all the sheets
that will be used for the export to different folders. ws.Copy will
copy the first sheet from ThisWorkbook.Sheets and create a new

I have a spreadsheet that will be printed onto a preprinted form.  I need to
calculate the value in a cell and then pad that cell with repeating hyphens
to fille out the remainder.
How can I determine how many hyphens I need to generate?

I have the following to find files in a folder with .xls extension.
Dim MyPath As String
FilesInPath = Dir(MyPath & "*.xls")
How would tweak this to find excel files that start with "1_"?

hi - i need to format the caption section of the user form......particularly
change font type, change background color of the caption section and also
center the caption. i would ideally like this to happen during initialize and
so would put the code in Initialize sub.

Hello group,
I have a macro to pull the values in row A and B of a workbook, to
another workbook. I have some values in the files that have *.txt and
*.log extension.

I have 2 workbooks open in Excel.
I am trying to write code to minimise the active workbook
to the taskbar, then, when it gets there,  save any changes made.
I'm using:-

I am using excel 2007. is it possible that when you open excel file
then a message should come up in wordart saying "DONT MAKE CHANGES"
then after 5 seconds it disappear. Basically i want some sort of macro
in excel file that when someone open the file a message should appear

I have a UserForm that is loaded by an Worksheet_SelectionChange event.  
Since the listboxes in the form are loaded with relative values, I want to
unload the form when either the OK or Cancel button is clicked.
I've tried both "unload me" and "unload frm_spread" in the button ...

Wondering how to do a search for .htm files that are all under one
main folder, but also through a bunch of subfolders under the main
folder.  The code I have so far is:
   myPath = "C:\MySites\"