Help with files opening automatically - solved!

skbailey11

New Member
Joined
Mar 24, 2006
Messages
26
The background is that I only use macros for a few limited files to save me some time spent on monotonous clicking. Well, yesterday I made three little macros that clear the info in three weekly files and save each with a new date (in preparation for me adding the new info). When I left yesterday, the macros worked as intended. I come in to work this morning, and each of those files now open automatically whenever I open any other file in Excel (just for the first one, nothing happens if I open a second).

Does anyone have a guess as to what I did? The three macros are all contained in a single module in my personal.xls file.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
57,261
Office Version
  1. 365
Platform
  1. Windows
Do a search for folders named "XLSTART" and see if any of the files have accidentally been saved in there. That would cause them to open whenever excel is opened.
 

skbailey11

New Member
Joined
Mar 24, 2006
Messages
26
Thank you!

Thank you for your suggestion! Those three files had been listed in my xlstart folder along with my personal.xls file. I'm guessing that my first versions of the macros unintentionally saved them there.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
57,261
Office Version
  1. 365
Platform
  1. Windows
Re: Thank you!

Thank you for your suggestion! Those three files had been listed in my xlstart folder along with my personal.xls file. I'm guessing that my first versions of the macros unintentionally saved them there.
No problem. I presume that you have now removed them from your XLSTART folder and everything is now in order. :biggrin:
 

Forum statistics

Threads
1,181,102
Messages
5,928,067
Members
436,586
Latest member
latintxn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top