If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Removing Macros
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 |
#2
|
|||
|
|||
Removing Macros
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 wrote: 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 |
#3
|
|||
|
|||
Removing Macros
"Dave Peterson" wrote in message ... 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 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 wrote: 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 |
#4
|
|||
|
|||
Removing Macros
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 wrote: "Dave Peterson" wrote in message ... 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 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 wrote: 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 -- Dave Peterson |
#5
|
|||
|
|||
Removing Macros
"Dave Peterson" wrote in message ... 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 |
#6
|
|||
|
|||
Removing Macros
Debra does nice work!
Bob Smith wrote: "Dave Peterson" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Buttons linked to Macros | surveyorinva | General Discussion | 1 | June 16th, 2004 06:37 PM |
Removing macros from a wokbook | mark g | Worksheet Functions | 2 | June 10th, 2004 11:34 PM |
Excel sees macros which are not there. | Terry | Setting up and Configuration | 5 | April 7th, 2004 02:14 AM |
How to avoid the file that conatain macros | Nikos Yannacopoulos | Worksheet Functions | 0 | March 22nd, 2004 02:11 PM |
Removing Macros | Gray | Worksheet Functions | 2 | September 18th, 2003 07:17 AM |