make the workbook a window and right click on the blue title bar at the top
of the window - select view code. put the code there. Save and close the
workbook. Open it back up.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

http://msdn.microsoft.com/office/und...d/default.aspx

--
Regards,
Tom Ogilvy


"Stonewall" wrote:

Hi,

I am also trying to create a wizard in excel, but I know virtually nothing
about VBA or creating macros. First of all, where do you enter the code? I
tried Mike H's code, but I couldn't seem to get it to work. I am using Excel
2007.

Thanks

"Jim Cone" wrote:


Be aware that VBA code affecting menus/toolbars will (mostly) not work in XL2007.
A different programming language is required to do that in XL2007.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Jason Paris"
wrote in message
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