personal macro workbook just stopped loading

[GoBobbyGo]

I don't know what I did...

Excel 2002

The workbook's still there. It still seems to be in the default location
(c:\documents and settings\~my user name~\application
data\microsoft\excel\XLSTART)

When I go to tools --> options --> general, the box for 'at startup, open
all files in' is blank.

So I navigate to the folder with personal.xls in it, and paste that address
into the box, hit ok, reopen the window, and it's gone.

I can TYPE the address into that box, but it still doesn't cause the macro
workbook to load upon reopening.

[Desert Piranha]

I don't know what I did...

Excel 2002

The workbook's still there. It still seems to be in the default location
(c:\documents and settings\~my user name~\application
data\microsoft\excel\XLSTART)

When I go to tools --> options --> general, the box for 'at startup, open
all files in' is blank.

So I navigate to the folder with personal.xls in it, and paste that address
into the box, hit ok, reopen the window, and it's gone.

I can TYPE the address into that box, but it still doesn't cause the macro
workbook to load upon reopening.

Hi GoBobbyGo,

I have xl2000 so it may be different but "tools --> options --> general" dosen't show the pesonal.xls.
That is for the default directory you are working with, and an alternate. The personal.xls would be shown in "Window<Unhide" assuming its hidden like it should be.

[GoBobbyGo]

Thanks, but it's not that. The personal workbook is not hidden, it's just
not open. And, yes, in XL 2002, there's a box on tools --> options -->
general for 'at startup, open all files in'.

"Desert Piranha" wrote:

>
> GoBobbyGo Wrote:
> > I don't know what I did...
> >
> > Excel 2002
> >
> > The workbook's still there. It still seems to be in the default
> > location
> > (c:\documents and settings\~my user name~\application
> > data\microsoft\excel\XLSTART)
> >
> > When I go to tools --> options --> general, the box for 'at startup,
> > open
> > all files in' is blank.
> >
> > So I navigate to the folder with personal.xls in it, and paste that
> > address
> > into the box, hit ok, reopen the window, and it's gone.
> >
> > I can TYPE the address into that box, but it still doesn't cause the
> > macro
> > workbook to load upon reopening.Hi GoBobbyGo,
>
> I have xl2000 so it may be different but "tools --> options -->
> general" dosen't show the pesonal.xls.
> That is for the default directory you are working with, and an
> alternate. The personal.xls would be shown in "Window<Unhide" assuming
> its hidden like it should be.
>
>
> --
> Desert Piranha
>
>
> ------------------------------------------------------------------------
> Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
> View this thread: http://www.excelforum.com/showthread...hreadid=573645
>
>

[Dave Peterson]

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

(If you don't have a backup, take the time now and create one.)

GoBobbyGo wrote:
>
> I don't know what I did...
>
> Excel 2002
>
> The workbook's still there. It still seems to be in the default location
> (c:\documents and settings\~my user name~\application
> data\microsoft\excel\XLSTART)
>
> When I go to tools --> options --> general, the box for 'at startup, open
> all files in' is blank.
>
> So I navigate to the folder with personal.xls in it, and paste that address
> into the box, hit ok, reopen the window, and it's gone.
>
> I can TYPE the address into that box, but it still doesn't cause the macro
> workbook to load upon reopening.

--

Dave Peterson

[GoBobbyGo]

Thanks. That solved the problem.

"Dave Peterson" wrote:

> xl2002+ has the abililty to quarantine what it thinks are bad workbooks.
>
> They can keep track of them so that it doesn't even try to open them.
>
> If you look under Help|About MS Excel, you'll see a button called: "Disabled
> Items...".
>
> Check under there to see if it's marked not to open. You can enable it there,
> too.
>
> If the workbook is really bad, you may want to delete that copy and put a copy
> of your backup version into your XLStart folder.
>
> (If you don't have a backup, take the time now and create one.)
>
> GoBobbyGo wrote:
> >
> > I don't know what I did...
> >
> > Excel 2002
> >
> > The workbook's still there. It still seems to be in the default location
> > (c:\documents and settings\~my user name~\application
> > data\microsoft\excel\XLSTART)
> >
> > When I go to tools --> options --> general, the box for 'at startup, open
> > all files in' is blank.
> >
> > So I navigate to the folder with personal.xls in it, and paste that address
> > into the box, hit ok, reopen the window, and it's gone.
> >
> > I can TYPE the address into that box, but it still doesn't cause the macro
> > workbook to load upon reopening.
>
> --
>
> Dave Peterson
>