Macros
Macros
(OP)
i've created a few macors ,but ever since a file ( personal.xls) opens eahc time i start excel ,is there a way to stop it from opening , i know that my macros are stored in it so i don't want to delete it.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love Eng-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Macros
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Macros
RE: Macros
I’ve tried what you suggested, but unfortunately it didn't work ,i changed the file name to AAA ,but it loaded AAA ,so it is the same , if i tried to remove it from the default directory my macros will not load ,i want to stop this file from running and the same time keep the macros available through (TOOLS\Macros ) in excel. when i first created the macros this file didn't load but then something happened and it didn't load now it's coming again and i can't figure it out , ,
and furley I’m not that professional in excel so i don't know what r u talking about.
Please help.
RE: Macros
If you don't want them to load then you need to move it to another directory.
RE: Macros
I don't really understand why you don't want the "personal" file to open... It's hidden and you don't even know it's there unless you are working in VBA. Is there something I'm missing??
jproj
RE: Macros
I can get rid of it by moving personal.xls to another directory (not xlstart), but then I don't have my macro's available unless I go find the file and open it.
RE: Macros
RE: Macros
Hide a workbook
1 Open the workbook.
2 On the Window menu, click Hide.
Note When you quit Microsoft Excel and a message asks if you want to save changes to the hidden workbook, click Yes. The next time you open the workbook, the workbook window remains hidden.
Regards,
Joerd
RE: Macros