A lot of questions and to move forward you may have to ask specific ones.
However,

Is it possible to create a custom wizard that runs when the workbook opens?
Yes it is they are called macros and here is a very simple one that will run
every time the workbook is opened.

Private Sub Workbook_Open()
msg = "Hello user press yes or no please"
response = MsgBox(msg, vbYesNo)
If response = vbYes Then
MsgBox ("You pressed yes")
Else
MsgBox ("You pressed No")
End If
End Sub

working with command bars can be done for example

Sub DeactivateIt()
With Application.CommandBars("Worksheet Menu Bar").Controls("&Tools")
.Controls("&Options...").Enabled = False
End With
End Sub

Will disable Options on the tools menu

Mike


"Jason Paris" wrote:

Okay.....don't laugh. I know virtually nothing about VBA, so go easy
on me........

I've been asked to create an "application", 95% of which is pure
Excel: formulas, functions and the like. The remaining 5% is stuff
which is customisable, based on input from the user (ie, requiring
VBA). Part of this is a custom-built Wizard, so.........

Is it possible for a custom Wizard to be created using VBA? And if
so, can it appear immediately after the user opens the Workbook?

And how about creating custom menu bars and menu items (and hiding the
built-in bars/items)........is this also possible with VBA? Can
someone show me how it's done?

Many thanks in advance. :)

Jason Paris