Hello group!
I have a (hopefully) quick query.  Can anybody help?
I am writing a procedure and require a function which reads a file
path string and returns true or false depending on whether the file

How can I filter a protected shared worksheet?
I have allowed filtering in protection & can filter the protected worksheet
manually but if I try using vba it says its protected. I can't unprotect then
filter because it's a shared workbook.

I have the following sort macro:
    Cells.Select
   Selection.Sort Key1:=Range("L2"), Order1:=xlAscending,
Header:=xlYes

I have written a simple function (just for test) (opening VBA with alt-F11):
Public Function XX()
   XX = 7.45
End Function

Is there a way to declare a collection object as a collection of a
particular type of object or as a collection of a particular class?  Would
like this for intellisense purposes.

I need to create a macro & assign it to a button.  the macro needs to save
the current file based on a date that is entered in a cell.  also the macro
needs to prompt the user to verify the filename(date) and then save it and
return to the current worksheet.

Hi all i am not a programmer but a dabbler and need help with changing the
widths of 51 columns, all variable in width.
What would be the best way to do this, it must be done by code ?
A lot of the columns are the same width, but spaced apart from each other..

HI, I have a excel form that has a password protection, a person can
only enter information in unprotected cells only. My question is this,
is there any other way to use protection that can not be easilly
cracked. thanks

I have a macro that I use to save a sheet as a new file. Now I have a
requirement that it needs to be saved as only XLS and not xlsx. The
macro is used in computers with Excel 2007.
The code snippet is as follows:

I'm still not good with setting up loops.  I'm trying to create a simple
macro to sum the values in columns L through O, and put the results in Column
P.  i want the loop to run until it detects blanks in Column K.
Sub FillDown()

I have a problem with userform textbox formatting. The end result of data
entry is to be shown as 01/01234 or BH/014567 the first two characters is a
claim year (can be 01 for 2001etc or BH for really old claim prefix) and the
last 5 numbers are a file number (always 5 numbers).

Hi!  I have several CSV files that I am exporting from a server, and I bundle
them with a pre-formatted XLS that has an Auto-Open macro that brings them
all into the spreadsheets in the appropriate location.  The whole package is
zipped up and emailed to my users in a batch ...

I have a worksheet that gets populated with up to 60 little pictures.
My macro uses the Application.screenupdating=false and true to help
with flicker and speed when it is putting them on the sheet. My
question is with just plain scrolling up and down the worksheet, using

I have adopted some code I received from this forum to create a personalized
toolbar, hide all menus and other toolbars, as well remove the formula bar,
worksheet tabs, and column/row headings.
The code runs in the ThisWorkbook module in both the WindowActivate and

I am getting data using microsoft query from a flat file database, but
because I am using a query that can not be graphically displayed, it will not
let me pass a parameter to the query.  In frustration, I have dumped all the
data to an excel spread sheet (Open Orders.xls) and ...