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
- Oct 22 Sun 2006 20:09
Macro in Excel 2000
close
全站熱搜
留言列表
發表留言