close

I have created a macro and saved it in PERSO.XLS.
Now, I want to remove that macro but I get the message that the file is in a
hidden directory. I have tried wiithout success to find that directory by
making the hidden files and directories visible in the quot;Microsoft
Office\Officequot; directory which is where my Excel.exe file is located.
Anybody have an idea on how to get rid of that macro ?
please reply via E-Mail preferably to :

Thanks !
First, is it really named PERSO.xls.

Most times, it's named personal.xls

If you open excel and perso.xls opens, then you can use that to help:

hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)
type this and hit enter:
?workbooks(quot;perso.xlsquot;).fullname

If there's only one macro in that workbook, then you can close excel and delete
that file.

If there are other macros in that workbook that you want to keep, then I'm not
sure what you're asking.

Change the name what you need (perso.xls or personal.xls).Raymond Dorais wrote:
gt;
gt; I have created a macro and saved it in PERSO.XLS.
gt; Now, I want to remove that macro but I get the message that the file is in a
gt; hidden directory. I have tried wiithout success to find that directory by
gt; making the hidden files and directories visible in the quot;Microsoft
gt; Office\Officequot; directory which is where my Excel.exe file is located.
gt; Anybody have an idea on how to get rid of that macro ?
gt; please reply via E-Mail preferably to :
gt;
gt; Thanks !

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()