'preciate you all sharing your know-how. very helpful... yeah, this is the
second time this PERSONAL.XLS was taking things personal with me! And on my
own laptop this time (vs. the at-work pc).... how rude! The last time I got
around it by making an all-out search for PERSONAL.XLS and once found, I
created a shortcut to where I could open it anytime I needed it (almost
everytime I opened Excel). I did not lose any macros, but it was a very ugly
and cheap solution nonetheless. Almost as good as using a paper clip to
replace a screw in my glasses. I also did not know that Excel creates a
PERSONAL.XLS the first time you create a macro... that may be useful if you
want to start your macros from scratch again. But still, the solution Gord
Dibben and Chip Pearson gave is the best... about going to "Help" on the
Excel Menu, then "About Microsoft Excel", then "Disabled Items", then
"PERSONAL.XLS", then "Enable", then exiting Excel so that it will take
effect. Wow... and this way you don't lose any macros you may have had there
and you don't have to open PERSONAL.XLS everytime you need it (like I did for
about six months). Glad you guys answered Jack & ggt.... 'cause I was #3.

dantee.


"ggt" wrote:



"Jack" wrote:

A week ago, the personal workbook under xlstart folder was opening when I
start excel. it has all my macros that I use. I dont know what happened but
it stopped opening the personal workbook on startup. My macro security is on
Low.

I don't know what is happening. Can anyone help...

I have the same problem you had a while ago. Did you manage to solve it?