Hi Gary

The user might or might not have a workbook open already before open my
userform by clicking my menu. But in a typical situation, the user would
start the Excel application, which by default opens with a new workbook,
Book1, as normal (or they might have some workbooks they're working in open
already). They may then click on my menu in the toolbar to open my userform.
So I guess this fits what you said about "using a menu in one workbook to
open another workbook"?

I've just tried your suggestion to hold the Shift key while clicking on my
menu with Book1 open. This opens my userform OK, but Book1 now appears above
my workbook (i.e. Book1 becomes the current workbook) and whatever I do in my
userform that has a reference to my workbook throws a run-time error "9:
Subscript out of range". I guess I need a line to make my workbook current
when my userform open to solve this problem? And if so, can you please show
me how?

I'm using 2003, but where would I find the run box you mentioned and what
does it do?

Thanks for your patient.

Sam

"Gary Keramidas" wrote:

a couple of thoughts:

are you using a menu in one workbook to open another workbook? if so, open the
2nd workbook manually and see if it works..

if the form is set to run on open:
1. hold the shift key while you open the 2nd workbook so excel opens in safe
mode (or if you're running 3003 and installed in the default location, type this
in the run box:
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /s

.. then look at your form code. if it's ok, export the form, delete it. open the
workbook and import the form and see what happens.

--


Gary


"Sam Kuo" wrote in message
...
Hi

Sorry the story may seem long winded, but I'm trying to describe it
logically so the problem can be easily understood.

I have added a new menu to the toolbar at the top of Excel, and assigned a
macro (called "USLE") to it that opens a userform. It was all working fine
until I made some changes to my VBE code, and I don't know what I've done
that causes the Excel to shut when I click on my menu...

Here is what happens:
When I click on my menu, the Security Warning window prompts and I click
"Enable Macros" as usual, the workbook then opens (but NOT the userform when
it should!), and an error message prompts saying "Microsoft Office Excel has
encountered a problem and needs to close", with the "Recover my work and
restart Microsoft Office Excel" option checked.

If I click on the recovered file in the Document Recovery panel in the left
of the new Excel opened automatically, save it and close the workbook (but
keep the Excel open), then click on my menu again, the userform then opens OK
and everything is fine!

However, if I start a new Excel application and click on my menu, the same
problem happens again...

Why is this?