| Home |
| Search |
| Today's Posts |
|
#13
|
|||
|
|||
Your code:
Application.DisplayAlerts=False ThisWorkbook.ChangeFileAccess xlReadOnly Kill ThisWorkbook.FullName ThisWorkbook.Close False ThisWorkbook means the workbook that contains the code. If only you had used Activeworkbook! Losse wrote: That's correct. The PERSONAL.XLS is gone completely. Yes, I did run code from a macro in the PERSONAL.XLS. Why would it have killed the macros instead of book1? I have no idea why killing the current file would have deleted all of my macros. -- Losse ------------------------------------------------------------------------ Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813 View this thread: http://www.excelforum.com/showthread...hreadid=386932 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect macros? | Excel Discussion (Misc queries) | |||
| Enabling macros | Excel Discussion (Misc queries) | |||
| Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
| The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
| Macros disappear after a file is imported | Excel Discussion (Misc queries) | |||
Threaded Mode
