I have the following code that, on close, it hides all the Sheets
except Splash. Problem is I'm getting a debug on -
ws.Visible = xlVeryHidden
It says - Unable to set the visible property of the worksheet class

I have received the following code from this WG, which places code
within ThisWorkbook, problem is I'm receiving a syntax error on both
message 1 & 2 and I'm just about lost at this stage of where I'm gone
wrong, any help appreciated

I am starting a small business and will be bookkeeping with Access 2003
Pro. I want to export the specific data from my database into a
pre-made Excel 2003 Pro Invoice. Can anyone shed some light on how I
can accomplish this are direct me to a website in which I can

i am having issues using VBA code for opening up workbooks within a
workbook.
i need to open up 6 other workbooks when the master workbook is opened.
i was playing around with some code i found on this group and i got 1

Hi group,
WinXP Pro
Office 2003
I have created a userform with a frame and 22 optionbuttons. I have

I have the following code which deletes all Range Names in a Workbook.
How would I delete all except for 1 Range Name called "MyUsers"
   For Each nName In ActiveWorkbook.Names
   nName.Delete

Select OR Activate ? Which when and Why?
i have never been able to work out when i should select and when i
should activate when using vba - does anyone have a good explanation?

I have a list of Dates in a mmmm yy format in sheet1.Range("B17:B28")
When i run a macro in another sheet, i want the Currrent (mmmm yy) to be
placed in the corresponding row in  Column C.
I have the Current (mmmm yy) in sheet5.Range("B1") where i run the macro

Excel VBA on my work PC throws errors when I try to refer to the class
'FileSystemObject' or its associated constants (such as 'WindowsFolder').
Which library is the one I need a reference to?
Thanks!

Does anyone know where and if I can buy
Professional Excel Development: The Definitive Guide to Developing
Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley
Microsoft Technology Series) (Paperback)

i have a listbox populated with data.....
the control works fine, but how do i increase the amount of lines of data
the control can keep?
thanx in advance

I undertook some programming in Excel 2003 but my new employer only uses
Excel 2002 (10.6823.6817) SP3.  The hyperlinks, drop-down menus and
calcuations all seem to work fine but the program was written such that when
it was opened a box appeared asking for a password so that ...

Here's one for you..
I've got a modeless userform firing up after a 'Application.Visible =
False'.  Because I want to get into the code and continue editing I've
added a 'view worksheet' button to the form that does a

I've googled w/out any luck... does anyone know if there is a way to detect
what a user's default Text to Column delimiters are and restore them at the
end of the macro?
If I cannot restore the user's previous setting, is there a way to at least

I have a spreadsheet with 1000+ rows.  Column X contains a blank field that
represents a complete date.  When the user enters in a complete date
(xx/xx/xx), I would like the row from column A through column AK to change to
a different color.  The complete dates may be entered ...