I have set-up Validation for use in four locations in my "form" spreadsheet;
sheet 1 is the form; sheet 2 & 3 contain the ranges for the drop down lists;
all works ok, except----
1) all four ranges produce a drop down list in which the fonts are very

Code almost working..
Sub Foo()
Set rng = Range("Mylist")   'Range("A4:F10")
Set nrng = rng.Offset(4).Resize(rng.Rows.Count - 4) 'Range("A8:F10")

Is it possible to not open a workbook (either through Excel or
double-clicking the file in explorer) if macros are automatically
disabled or the user decides not to enable the macros?
If so, I would like for it then to display a msgbox informing the user

At what occasion do you create a class module?
What can class modules do?
How do you fill a class module?
I know about modules and user-functions as addinn, how to create a

I am new to VBA and seeking help. I am basically needing to hide all range
columns with exception of columns whose headers are that of East Coast
cities. How do I accomplish this? Thanks

I have just built a spreadsheet that includes about 32 macros and they don't
always seem to function correctly. I essentially have built a game where when
an icon is clicked a value located in another worksheet will appear. Thus, I
have built a number of macros that are assigned ...

I'm trying to create a button that when a month is selected (using a
drop-down box) and the button is clicked it either
a) if the sheet currently exists - goes to the chosen tab         OR
b) if the sheet does not exist - creates a copy of the master sheet and

Hello Ron, or others knowledgable in VBA... I am using the calander code
found http://www.rondebruin.nl/calendar.htm and want to control the size of
the calander so that it doesn't change with the column width.  How would I do
that?  

I have created a workbook that records the user name, date and time the
workbook was opened in a hidden worksheet, but as it is updated it asks
the user whether to save the workbook of the changes or not before exiting.
I would like the workbook to automatically save ONLY the ...

Can someone explain to me why a code that works in OfficeXPsp2 French does
not work in Office2003 English.
codes such as;
appplication.displayalert=  false

I am getting the error "Object Variable or With Block Variable not set"
when I try to execute following VBA code.
Dim a As Excel.Application
Dim wb As Workbook

I have the following code, based on that at Ron de Bruin's site, which
creates emails exactly as required, except that the SendKeys line does
nothing. I've tried some variations of syntax, and it doesn't give an
errormessage, but it just doesn't send. Does anyone have a suggestion ...

I've always used excel to track data regarding my domain names.  I was
wondering if anyone has ever come across a macro or knows how to create one
that would add a little more functionality to my excel sheet.
In column A, I have a list of all my domain names (eg domain.com).  In

Could anybody PLEASE help!??
I am trying to import a lot of seperate dat files into a single
worksheet, but every time i try and do this it opens up a seperate
sheet for each file!!

I have a problem which I hope someone can help with.
I have a workbook which has two sheets.
Sheet one is used to list the assets and Liabilities for a person.
Sheet two is essentialy a copy of the details on one with a couple of