PESONAL WORKBOOK PLEASE HELP
 

When ever I open Excel it doesn't open with a blank workbook as per normal,
(eg. workbook1 or 4 or something) it opens with PERSONAL.

I am not sure how I did this, I think it may have been a macro,(that's why
I';ve put it in programming) I've tried deleting all the macros that I can
find and it's still doing this.

Please if anyone knows how to stop this, could you please help me

Thankyou for your help in advance

Dan

--
iPod's ROCK!

PESONAL WORKBOOK PLEASE HELP
 

If you're sure you don't have any macros that are in personal.xls that you want
to keep, you can delete that workbook (or move it somewhere else if you want).

Next time you open excel, type this in a cell in personal.xls
=cell("Filename",a1)

Note the location of that file.

Close excel.
Use windows explorer to go to that folder.
Either move personal.xls to a different folder or just delete it.

DanielWalters6 wrote:

When ever I open Excel it doesn't open with a blank workbook as per normal,
(eg. workbook1 or 4 or something) it opens with PERSONAL.

I am not sure how I did this, I think it may have been a macro,(that's why
I';ve put it in programming) I've tried deleting all the macros that I can
find and it's still doing this.

Please if anyone knows how to stop this, could you please help me

Thankyou for your help in advance

Dan

--
iPod's ROCK!

--

Dave Peterson

PESONAL WORKBOOK PLEASE HELP
 

Close Excel
find the workbook personal.xls in the xlstart directory and delete it.

Use file=Find in the Windows Start

--
Regards,
Tom Ogilvy


"DanielWalters6" wrote in message
...
When ever I open Excel it doesn't open with a blank workbook as per
normal,
(eg. workbook1 or 4 or something) it opens with PERSONAL.

I am not sure how I did this, I think it may have been a macro,(that's why
I';ve put it in programming) I've tried deleting all the macros that I can
find and it's still doing this.

Please if anyone knows how to stop this, could you please help me

Thankyou for your help in advance

Dan

--
iPod's ROCK!

PESONAL WORKBOOK PLEASE HELP
 

After many failed attemtps (not sure why)

It finally worked.

thank you for your time

Dan


--
iPod's ROCK!


"Tom Ogilvy" wrote:

Close Excel
find the workbook personal.xls in the xlstart directory and delete it.

Use file=Find in the Windows Start

--
Regards,
Tom Ogilvy


"DanielWalters6" wrote in message
...
When ever I open Excel it doesn't open with a blank workbook as per
normal,
(eg. workbook1 or 4 or something) it opens with PERSONAL.

I am not sure how I did this, I think it may have been a macro,(that's why
I';ve put it in programming) I've tried deleting all the macros that I can
find and it's still doing this.

Please if anyone knows how to stop this, could you please help me

Thankyou for your help in advance

Dan

--
iPod's ROCK!

PESONAL WORKBOOK PLEASE HELP
 

Dan

As an alternative you could always "Hide" Personal.xls so's it opens but is
hidden from view.

With it open go to WindowsHide then close Excel. Click "Yes" when asked to
save changes to Personal.xls.

Then any global macros will be available for any and all open workbooks.

That is the function of the Personal.xls workbook.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 13:42:03 -0700, "DanielWalters6"
wrote:

After many failed attemtps (not sure why)

It finally worked.

thank you for your time

Dan

PESONAL WORKBOOK PLEASE HELP
 

Thankyou, but I don't regularly use the same macros.

Thank you for your help all the same. Have made a mental note of a few way
in which I can hide a workbook in future.

P.s. You know how you can make two workbooks open at the same time? Eg. when
creating a shortcut to a file, can you make it so that it opens two?

Or when I was to open one workbook, another one would open hidden.

Thank's for the help

Dan
--
iPod's ROCK!


"Gord Dibben" wrote:

Dan

As an alternative you could always "Hide" Personal.xls so's it opens but is
hidden from view.

With it open go to WindowsHide then close Excel. Click "Yes" when asked to
save changes to Personal.xls.

Then any global macros will be available for any and all open workbooks.

That is the function of the Personal.xls workbook.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 13:42:03 -0700, "DanielWalters6"
wrote:

After many failed attemtps (not sure why)

It finally worked.

thank you for your time

Dan

PESONAL WORKBOOK PLEASE HELP
 

Dan

You can place the hidden workbook in your XLSTART or Alternate startup folder
designated at ToolsOptionsGeneral and it will open hidden whenever Excel is
started.

If always to be the same file you can have a shortcut to any other file and
both will open, one of them hidden.

I can't think of any way to open two files from a single shortcut.


Gord

On Wed, 28 Sep 2005 11:19:03 -0700, "DanielWalters6"
wrote:

Thankyou, but I don't regularly use the same macros.

Thank you for your help all the same. Have made a mental note of a few way
in which I can hide a workbook in future.

P.s. You know how you can make two workbooks open at the same time? Eg. when
creating a shortcut to a file, can you make it so that it opens two?

Or when I was to open one workbook, another one would open hidden.

Thank's for the help

Dan

PESONAL WORKBOOK PLEASE HELP
 

Daniel, don't you mean opening same file in two or more windows?
You can do that by clicking on Window-New Window. Then arrange according ur
need.

"DanielWalters6" wrote:

Thankyou, but I don't regularly use the same macros.

Thank you for your help all the same. Have made a mental note of a few way
in which I can hide a workbook in future.

P.s. You know how you can make two workbooks open at the same time? Eg. when
creating a shortcut to a file, can you make it so that it opens two?

Or when I was to open one workbook, another one would open hidden.

Thank's for the help

Dan
--
iPod's ROCK!


"Gord Dibben" wrote:

Dan

As an alternative you could always "Hide" Personal.xls so's it opens but is
hidden from view.

With it open go to WindowsHide then close Excel. Click "Yes" when asked to
save changes to Personal.xls.

Then any global macros will be available for any and all open workbooks.

That is the function of the Personal.xls workbook.


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 13:42:03 -0700, "DanielWalters6"
wrote:

After many failed attemtps (not sure why)

It finally worked.

thank you for your time

Dan