View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Macro in Excel 2000

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("perso.xls").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:

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 "Microsoft
Office\Office" 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 !


--

Dave Peterson