I designed a form, which on open of excel gets the focus, on which I had a
button to allow me to get to the code whilst developing the form. I copied
the button then made the original button not visible. I then opened the form
only to find that neither button worked. Now when I open excel it sets the
focus to the form and I cannot get off the form to the code to put the button
back to visible or to make any other changes. The form on close opens
outlook and when outlook closes it closes excel.
How can I get off the form to allow me to edit the code or a worksheet or
infact anything? I have a lot of code on the form so to have to start again
and design from scratch - the words "harry carry" come to mind. Thanks to
anyone who can help.
--
Kaz

Hi,

With Excel open and the file closed choose File, Open while keeping the
Shift key depressed, pick the file and open it. This will disable the macro
that is displaying the form and you can then go to the VBE and correct the
problem.

Alternatively you can choose Tools, Macro, Security and set the security to
High. Then open the file and choose Disable Macros when prompted.

--
Cheers,
Shane Devenshire


"Kaz G" wrote:

I designed a form, which on open of excel gets the focus, on which I had a
button to allow me to get to the code whilst developing the form. I copied
the button then made the original button not visible. I then opened the form
only to find that neither button worked. Now when I open excel it sets the
focus to the form and I cannot get off the form to the code to put the button
back to visible or to make any other changes. The form on close opens
outlook and when outlook closes it closes excel.
How can I get off the form to allow me to edit the code or a worksheet or
infact anything? I have a lot of code on the form so to have to start again
and design from scratch - the words "harry carry" come to mind. Thanks to
anyone who can help.
--
Kaz