software

Hi all

A colleague of mine has created a macro but rather than saving it into the
current workbook has saved it to the personal macro workbook.

It now says that the personal workbook is hidden. We have tried to delete
the macro and it says it cannot find thie hidden workbook.

How can I delete this macro and close the personal macro workbook???

THank you.

Louise

Hi Louise. Have you tried going to Windows menu and unhide. This should
allow you to access the Personal workbook.
--
Sincerely, Michael Colvinquot;Louisequot; wrote:

gt; Hi all
gt;
gt; A colleague of mine has created a macro but rather than saving it into the
gt; current workbook has saved it to the personal macro workbook.
gt;
gt; It now says that the personal workbook is hidden. We have tried to delete
gt; the macro and it says it cannot find thie hidden workbook.
gt;
gt; How can I delete this macro and close the personal macro workbook???
gt;
gt; THank you.
gt;
gt; Louise

Michael
No I haven't actually, I will try that. Once I find it though, how do I
get rid of it to stop it from opening each time I open Excel? I remember
somebody doing this once before and it caused us endless problems.

Thanks again.
Louise

quot;Michaelquot; wrote:

gt; Hi Louise. Have you tried going to Windows menu and unhide. This should
gt; allow you to access the Personal workbook.
gt; --
gt; Sincerely, Michael Colvin
gt;
gt;
gt; quot;Louisequot; wrote:
gt;
gt; gt; Hi all
gt; gt;
gt; gt; A colleague of mine has created a macro but rather than saving it into the
gt; gt; current workbook has saved it to the personal macro workbook.
gt; gt;
gt; gt; It now says that the personal workbook is hidden. We have tried to delete
gt; gt; the macro and it says it cannot find thie hidden workbook.
gt; gt;
gt; gt; How can I delete this macro and close the personal macro workbook???
gt; gt;
gt; gt; THank you.
gt; gt;
gt; gt; Louise


If it is just the one general purpose macro you have stored in the
Personal workbook then go to your XLStart folder which will be under
the Microsoft Office folder on your hard drive and delete the workbook
from there. Any macros attached to individual workbooks shouldn't be
affected.

That would be my suggestion, but as my signature says i'd possibly get
a second opinion --
penri0_0------------------------------------------------------------------------
penri0_0's Profile: www.excelforum.com/member.php...oamp;userid=28947
View this thread: www.excelforum.com/showthread...hreadid=542956
Hi Louise,

This is just an expansion on Penri's answer as he/she has hit it bang
on the button - it may may it quicker than searching for the XLstart
folder:

* To close the personal.xls file amp; learn where it is stored (for
deletion):
Follow Penri's suggestion of unhiding [alt w u], check the
File-Properties (ie [alt f i]), choose the quot;Generalquot; tab, read/copy
the quot;locationquot;, close the file, go to the location amp; delete file if
desired.

Just out of curiosity, what sort of quot;endless problemsquot; did you
experience?

hth
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=542956
just for the record i'm a 'he' --
penri0_0------------------------------------------------------------------------
penri0_0's Profile: www.excelforum.com/member.php...oamp;userid=28947
View this thread: www.excelforum.com/showthread...hreadid=542956THank yo for your reply.
The problem last time was every time Excel was opened, the personal workbook
was opened too by default, rather than just Book1, so we always had to close
it before we started to use Excel.

Louise

quot;broro183quot; wrote:

gt;
gt; Hi Louise,
gt;
gt; This is just an expansion on Penri's answer as he/she has hit it bang
gt; on the button - it may may it quicker than searching for the XLstart
gt; folder:
gt;
gt; * To close the personal.xls file amp; learn where it is stored (for
gt; deletion):
gt; Follow Penri's suggestion of unhiding [alt w u], check the
gt; File-Properties (ie [alt f i]), choose the quot;Generalquot; tab, read/copy
gt; the quot;locationquot;, close the file, go to the location amp; delete file if
gt; desired.
gt;
gt; Just out of curiosity, what sort of quot;endless problemsquot; did you
gt; experience?
gt;
gt; hth
gt; Rob Brockett
gt; NZ
gt; Always learning amp; the best way to learn is to experience...
gt;
gt;
gt; --
gt; broro183
gt; ------------------------------------------------------------------------
gt; broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
gt; View this thread: www.excelforum.com/showthread...hreadid=542956
gt;
gt;


Hi,
Pleased we could help :-)
Penri, I thought you were a he but didn't want to offend - the record
is all good.

Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=542956