I want to get rid of personal.xls. I don't need the macro. Personal is not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

Do a Windows search for it and delete it, if you have such strong feelings
against it. <g
__________________________________________________ _______________________

"Pat-southern-California"
wrote in message ...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

Open excel
Hit alt-f11 to get to the VBE
Hit ctrl-r to see the project explorer
verify that personal.xls appears in that window.

Hit ctrl-g to get to the immediate window
type this and hit enter:
?workbooks("personal.xls").path

You'll see the path displayed in that immediate window.
Copy that string

hit flying-windows-key-r to see the windows Run dialog.
(windows start button|run will work under some versions of windows)

Paste that into that run dialog
Windows explorer should open so you can the contents of that folder.

Do you see personal.xls?

If yes, then back to excel and close excel
(You won't be able to delete personal.xls if it's in use by excel)

Delete it (or move it to an out of the way location until you're sure you want
to delete it).



Pat-southern-California wrote:

I want to get rid of personal.xls. I don't need the macro. Personal is not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

--

Dave Peterson

I like my method better. It works even if personal.xls is not open. <g
__________________________________________________ ______________________

"Dave Peterson" wrote in message
...
Open excel
Hit alt-f11 to get to the VBE
Hit ctrl-r to see the project explorer
verify that personal.xls appears in that window.

Hit ctrl-g to get to the immediate window
type this and hit enter:
?workbooks("personal.xls").path

You'll see the path displayed in that immediate window.
Copy that string

hit flying-windows-key-r to see the windows Run dialog.
(windows start button|run will work under some versions of windows)

Paste that into that run dialog
Windows explorer should open so you can the contents of that folder.

Do you see personal.xls?

If yes, then back to excel and close excel
(You won't be able to delete personal.xls if it's in use by excel)

Delete it (or move it to an out of the way location until you're sure you
want
to delete it).



Pat-southern-California wrote:

I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

--

Dave Peterson

When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as a
*hidden workbook* when you start Excel. So, which of those "not hiddens" are
you referring to?

You need to set your folder options to display hidden files and directories
then you'll probably find it in the XLStart directory where you can delete
it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"
wrote in message ...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

Biff, congratulations! July 1?
__________________________________________________ _______________________

"T. Valko" wrote in message
...
When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as a
*hidden workbook* when you start Excel. So, which of those "not hiddens"
are you referring to?

You need to set your folder options to display hidden files and
directories then you'll probably find it in the XLStart directory where
you can delete it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"
wrote in message
...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

sorry to interrupt,

What's the main objective of the personal.xls in excellation...? before and
now..


regards,
driller
--
*****
birds of the same feather flock together..



"T. Valko" wrote:

When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as a
*hidden workbook* when you start Excel. So, which of those "not hiddens" are
you referring to?

You need to set your folder options to display hidden files and directories
then you'll probably find it in the XLStart directory where you can delete
it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"
wrote in message ...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

Yes. Thank you.

Also, welcome back! Haven't seen you around for a while.

--
Biff
Microsoft Excel MVP


"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
Biff, congratulations! July 1?
__________________________________________________ _______________________

"T. Valko" wrote in message
...
When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as a
*hidden workbook* when you start Excel. So, which of those "not hiddens"
are you referring to?

You need to set your folder options to display hidden files and
directories then you'll probably find it in the XLStart directory where
you can delete it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"
wrote in message
...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

Yeah, real life got in the way, etc. But hoping to get up to speed soon and
contribute regularly. :-)
__________________________________________________ _________________________

"T. Valko" wrote in message
...
Yes. Thank you.

Also, welcome back! Haven't seen you around for a while.

--
Biff
Microsoft Excel MVP


"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
Biff, congratulations! July 1?
__________________________________________________ _______________________

"T. Valko" wrote in message
...
When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as
a *hidden workbook* when you start Excel. So, which of those "not
hiddens" are you referring to?

You need to set your folder options to display hidden files and
directories then you'll probably find it in the XLStart directory where
you can delete it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"
wrote in message
...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there
either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

When you have macros and want those macros to be available to any workbook
you open, you store them in a file called Personal.xls which is stored in
the XLStart directory. The Personal.xls file opens as a hidden workbook when
you start Excel. This file doesn't exist until you create it by recording a
macro (or you could do it all manually). When you start the macro recorder
you're presented with a dialog box asking you where you want to store the
macro you're about to create.

For example, I do a lot of testing and need to generate lots of random
numbers all the time. So I have a macro that generates these random numbers.
I need to have this available to any file I'm working on so I store this
macro in Personal.xls. I added a custom button to one of my toolbars and
then assigned that macro to that button. This saves me a lot of time and I
don't have to fool around writing a bunch of RAND/RANDBETWEEN functions (and
their volatility).

--
Biff
Microsoft Excel MVP


"driller" wrote in message
...
sorry to interrupt,

What's the main objective of the personal.xls in excellation...? before
and
now..


regards,
driller
--
*****
birds of the same feather flock together..



"T. Valko" wrote:

When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as a
*hidden workbook* when you start Excel. So, which of those "not hiddens"
are
you referring to?

You need to set your folder options to display hidden files and
directories
then you'll probably find it in the XLStart directory where you can
delete
it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"

wrote in message
...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there
either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

thank you for the explanation...

regards,
driller
--
*****
birds of the same feather flock together..



"T. Valko" wrote:

When you have macros and want those macros to be available to any workbook
you open, you store them in a file called Personal.xls which is stored in
the XLStart directory. The Personal.xls file opens as a hidden workbook when
you start Excel. This file doesn't exist until you create it by recording a
macro (or you could do it all manually). When you start the macro recorder
you're presented with a dialog box asking you where you want to store the
macro you're about to create.

For example, I do a lot of testing and need to generate lots of random
numbers all the time. So I have a macro that generates these random numbers.
I need to have this available to any file I'm working on so I store this
macro in Personal.xls. I added a custom button to one of my toolbars and
then assigned that macro to that button. This saves me a lot of time and I
don't have to fool around writing a bunch of RAND/RANDBETWEEN functions (and
their volatility).

--
Biff
Microsoft Excel MVP


"driller" wrote in message
...
sorry to interrupt,

What's the main objective of the personal.xls in excellation...? before
and
now..


regards,
driller
--
*****
birds of the same feather flock together..



"T. Valko" wrote:

When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as a
*hidden workbook* when you start Excel. So, which of those "not hiddens"
are
you referring to?

You need to set your folder options to display hidden files and
directories
then you'll probably find it in the XLStart directory where you can
delete
it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"

wrote in message
...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there
either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

Lots of people have trouble using windows|search--especially finding files that
may be in hidden folders.

Shelling to DOS and doing
Dir C:\ personal.xl* /s

seems to help find files that windows|search (with the wrong settings) won't
find.

(What I'm trying to say is: I like mine better! <vbg)

Vasant Nanavati wrote:

I like my method better. It works even if personal.xls is not open. <g
__________________________________________________ ______________________

"Dave Peterson" wrote in message
...
Open excel
Hit alt-f11 to get to the VBE
Hit ctrl-r to see the project explorer
verify that personal.xls appears in that window.

Hit ctrl-g to get to the immediate window
type this and hit enter:
?workbooks("personal.xls").path

You'll see the path displayed in that immediate window.
Copy that string

hit flying-windows-key-r to see the windows Run dialog.
(windows start button|run will work under some versions of windows)

Paste that into that run dialog
Windows explorer should open so you can the contents of that folder.

Do you see personal.xls?

If yes, then back to excel and close excel
(You won't be able to delete personal.xls if it's in use by excel)

Delete it (or move it to an out of the way location until you're sure you
want
to delete it).



Pat-southern-California wrote:

I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

--

Dave Peterson

--

Dave Peterson

I would keep it, but I have to share the doc with others who feel it is
'confusing' and - well, they fight any feature I suggest tooth and nail.
They don't even like a suggestion of using absolutes or anything that would
take them, kicking and screeming into the 21st century.

When I taught MS Applications, many people were hesitant to use features
because they were used to manually doing so many things.

Thanks for this info, I could not remember how to get rid of that 'pesky'
feature!

"Vasant Nanavati" wrote:

Do a Windows search for it and delete it, if you have such strong feelings
against it. <g
__________________________________________________ _______________________

"Pat-southern-California"
wrote in message ...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

I do wish I were more versed in VBE. I have not been keeping up to date on
it and have not had the time to work on it. I can see your method will work
well and will keep a copy in my "stuff" file.

My stuff file is full of things I refer to all the time with great enthusiasm!

Thanks so much, Pat

"Dave Peterson" wrote:

Open excel
Hit alt-f11 to get to the VBE
Hit ctrl-r to see the project explorer
verify that personal.xls appears in that window.

Hit ctrl-g to get to the immediate window
type this and hit enter:
?workbooks("personal.xls").path

You'll see the path displayed in that immediate window.
Copy that string

hit flying-windows-key-r to see the windows Run dialog.
(windows start button|run will work under some versions of windows)

Paste that into that run dialog
Windows explorer should open so you can the contents of that folder.

Do you see personal.xls?

If yes, then back to excel and close excel
(You won't be able to delete personal.xls if it's in use by excel)

Delete it (or move it to an out of the way location until you're sure you want
to delete it).



Pat-southern-California wrote:

I want to get rid of personal.xls. I don't need the macro. Personal is not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

--

Dave Peterson

You're welcome!

--
Biff
Microsoft Excel MVP


"driller" wrote in message
...
thank you for the explanation...

regards,
driller
--
*****
birds of the same feather flock together..



"T. Valko" wrote:

When you have macros and want those macros to be available to any
workbook
you open, you store them in a file called Personal.xls which is stored in
the XLStart directory. The Personal.xls file opens as a hidden workbook
when
you start Excel. This file doesn't exist until you create it by recording
a
macro (or you could do it all manually). When you start the macro
recorder
you're presented with a dialog box asking you where you want to store the
macro you're about to create.

For example, I do a lot of testing and need to generate lots of random
numbers all the time. So I have a macro that generates these random
numbers.
I need to have this available to any file I'm working on so I store this
macro in Personal.xls. I added a custom button to one of my toolbars and
then assigned that macro to that button. This saves me a lot of time and
I
don't have to fool around writing a bunch of RAND/RANDBETWEEN functions
(and
their volatility).

--
Biff
Microsoft Excel MVP


"driller" wrote in message
...
sorry to interrupt,

What's the main objective of the personal.xls in excellation...? before
and
now..


regards,
driller
--
*****
birds of the same feather flock together..



"T. Valko" wrote:

When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens
as a
*hidden workbook* when you start Excel. So, which of those "not
hiddens"
are
you referring to?

You need to set your folder options to display hidden files and
directories
then you'll probably find it in the XLStart directory where you can
delete
it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"

wrote in message
...
I want to get rid of personal.xls. I don't need the macro. Personal
is
not
hidden but I cannot get to it. I went into XLStartup, not there
either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.

Personal.xls is usually a file that isn't shared with others.

Are you sure you're not just sharing a plain old data workbook with others. If
you are, then you having personal.xls on your pc should affect the others at
all.



Pat-southern-California wrote:

I would keep it, but I have to share the doc with others who feel it is
'confusing' and - well, they fight any feature I suggest tooth and nail.
They don't even like a suggestion of using absolutes or anything that would
take them, kicking and screeming into the 21st century.

When I taught MS Applications, many people were hesitant to use features
because they were used to manually doing so many things.

Thanks for this info, I could not remember how to get rid of that 'pesky'
feature!

"Vasant Nanavati" wrote:

Do a Windows search for it and delete it, if you have such strong feelings
against it. <g
__________________________________________________ _______________________

"Pat-southern-California"
wrote in message ...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.




--

Dave Peterson