I need to set up a log on through a user form when i open excel.  I need to
have two levels of access.  An Administrator level which can do everything
and a user level which can see the sheets and edit them. Can anyone help?

In VBA code I delete an existing worksheet.
while doing this a warning comes and questions if you wish to delete this
worksheet.
How can I make that this mesage does not appear?

I have a near empty sheet (has a few lines of data at the top of th
sheet) but when I go to print the sheet it comes out at 195 pages fo
some reason. I dont have any data at the bottom of the sheet, but exce
is picking something up that I cant see!

Hi Team
I am able to get the call for various "runner" macros to meet the specific
number in a cell I have named Starters, but I am unable to put the right End
If or end with or end loop.

I've a query  ...
Connstring =
"ODBC;DSN=simic;ArrayFetchOn=1;ArrayBufferSize=8;DBQ=simic;OpenMode=0;DecimalSymbol=,;ClientVersion=8.10.117.017;CodePageConvert=1252"
Sqlstring = "SELECT CentriDiProfitto.CodCentroProfitto,

I am novice in VBA.
Can someone please help me do the following.
I have 2 sheets
Sheet1 - contains all the information

i want to use colors in many "Cells" when i use "IF", for example if A1<0 i
want the color of A4 is yellow, else is REd

I created a spreadsheet that used a color scheme that was copied from
another spreadsheet that I had downloaded from a microsoft website.  I
recently opened that spreadsheet while I had a new one open and it
converted the colors in the new one to be the same.  I did not want

hay any one help me in opening an existing txt files with a macro or
VBA coding.
like i have differrent txt files in differrent file if open those file
each txt file will be opened in one excel but i want all of them to be

I would like to know if it possible to open the built-In Custom
AutoFilter dialog box programmatically.
Manually I get it through selecting a filtered field, followed by
choosing "Custom..." in the pull down list. The automatic solution is

Hi, this will be an easy one for you!
In my macro, I want to open a file based on a cell's contents.
So, if A1 contained "book1.xls", how do I open the file by referencin
the cell in the macro?

I have a list of data and I need to write a macro that would find rows which
contained duplicate information (except for the cells containing the
different quantities), combine them into one row entry with the total
quantity for all the duplicate rows and keep only one record.  ...

I'm looking to put in some sort of protection that will require a
password to run a particluar sub in an excel file.  The sub will be
attached to a button...
I had thought that I should pop up an input box (somehow!) and then

Dear group,
I have a weird problem concerning the difference between before_close
and auto_close. I used to use an auto_close macro which does a lot of
things (calling subroutines contained in separate modules!) and tried

hi, i'm a n00b on vba, can somebody tell me how to get (extract) the
folder name from ActiveWorkbook.Path? i read about InStr() &
InStrRev(), but i don't know how to use the result from InStr (as i
find below), and InStrRev i can't make sense of (returns 10 from