Removing Macros

[Bob Smith]

Hi folks,

Have a couple of problems, and was hoping for some help. First off, when I
boot up Excel with the /e function in the past, Excel would come up without
an open worksheet.

Since creating some macros, everytime I crank up Excel, the personal.xls
sheet is opening up.

Anyway to stop that?

Next, I set up some macros, and saved them "For all workbooks", instead of
just those specific workbooks. Big mistake, as now when I open any non
related workbook, I get the question whether to enable or disable macros,
even though no macros are showing up with I go into tools - macros.

I've deleted those macros, and recreated them just for the specific
workbooks and I'm still getting the Enable or Disable Macro question for
those unrelated workbooks.

Any ideas on what to do?

TIA,

Bob

 

[Dave Peterson]

You sure you don't have anything in personal.xls you want to keep?

If you're positive, you can
close excel
windows start button|find/search
personal.xls

Delete the file (maybe move it somewhere safe, just in case???)

If you have trouble finding it, try this:
Open excel
hitting alt-F11 (to get to the vbe)
hit ctrl-g (to see the immediate window)

type this and hit enter:
?application.startuppath

I get this using win98 and xl2002:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

============
If it turns out you actually want to keep the personal.xls file, but want to
have excel open it as a hidden workbook:

Open excel.
with personal.xls workbook active
Window|hide
Close excel
When prompted about saving personal.xls, answer yes.

restart excel. Personal.xls will open (but you won't see it).

 

[Bob Smith]

You sure you don't have anything in personal.xls you want to keep?

If you're positive, you can
close excel
windows start button|find/search
personal.xls

Delete the file (maybe move it somewhere safe, just in case???)

Thanks Dave. I'll keep it in the recycle bin for awhile. Any ideas on the
macro problem listed below. I'm still being ask on whether to enable or
disable workbooks, where they have no macros.

Bob

 

[Dave Peterson]

Sorry, I didn't see that part of the question.

If you get prompted for having macros in the old workbook (even though you
cut them out), a visit to Debra Dalgleish's site will help:
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Bob Smith]

Sorry, I didn't see that part of the question.

If you get prompted for having macros in the old workbook (even though you
cut them out), a visit to Debra Dalgleish's site will help:
http://www.contextures.com/xlfaqMac.html#NoMacros

Once again, thanks Dave. Worked like a charm ...

Bob

 

[Dave Peterson]

Debra does nice work!

Once again, thanks Dave. Worked like a charm ...

Bob