In Excel 2007, holding the shift key down does not disable the Workbook_Open
macro - is there a replacement?

Type:
User Input form
Problem #1:
Multiple search criteria is partially working. AppDate.Value works

Although I am skilled at VB, I am still new to programming with Excel and am
having a problem figuring out the proper syntax for refering to a cell and
getting it's value to use in code.
1. I have a workbook with multiple worksheets.

I have created an Evaluation Form in Excel 2003. For expeditious handling and
ease of use, I created an auto-correct function to replace lets say "S" with
"Satisfactory", "U" with Unsatisfactory, etc. (see actual code below).
However, it does not go with the workbook so I assume ...

For example
TabView-->TabView-->PlayMacro button. Can I hide or disable it?
Can anyone give me some way to complite it?
Thanks

One quick specific question re one wee oddity I have noted with the
following line of code:
Dim btnLB3 As CommandBarButton
Set btnLB3 =

I'm having issues with the following - pls help.
Dim myDt as variant
myDt = dateserial(myYr, myMonth,1)
myVariable = application.worksheetfunction.vlookup(myDt,Range("FUEL"),

I have listed in Sheet5 A1:A7, days i.e. Monday (A1) through Sunday
(A7). How would I via code, stamp in Sheet5 B1:B7 the current time
when an action is performed, depending on the Day of the week - 1
(minus one)?

Is there a way to import data to excel, from MS Access without haveing the
link referance a drive letter?  
I would like the spreadsheet to referance only the drive name.  This way
multiple users can update the excel file regardless of what drive letter they

Typed into a cell, this works:
=MDURATION("1/1/2008", "1/1/2016", ".08", ".09", "2", "1")
But I want to invoke the calc from afar (specifically MS Access VBA).
I can instantiate a copy of Excel, and invoke other routines like

This does not work:
Workbooks("Hot List.xls").Sheets("Snapshot").Cells.Copy
ThisWorkbook.Sheets(ShName).Range("A1").PasteSpecial xlColumnWidths
But this does:

It is claimed that, after
Set rng = Range("C1:C3")
with no variable declaration, rng is a Variant containing a Range type
variable of the same name, rather than that rng is simply a Range type

Good morning.  A couple of weeks ago, someone from this forum, was very
helpful in my question on how to unprotect protected worksheets, with similar
passwords, with a macro.  Below is a copy of the VB script I was given.  It
worked but then I realized, the password "hi" is now ...

I'd really like to do the following to try and speed things up a little.
   With .PivotTables("MyPivotTable")
       '.DeferLayoutUpdate = True
       .PivotFields("Field1").Orientation = xlRowField

I need help dealing with an error message on this line of code: "If c.Value =
"#N/A" Then". I keep getting a type mismatch error and I don't know why. I am
try to tell the programme to ignore any cell that contains "#N/A" and go on
to the next cell.