| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros - Peronal workbook
Hi all
A colleague of mine has created a macro but rather than saving it into the current workbook has saved it to the personal macro workbook. It now says that the personal workbook is hidden. We have tried to delete the macro and it says it cannot find thie hidden workbook. How can I delete this macro and close the personal macro workbook??? THank you. Louise |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros - Peronal workbook
Hi Louise. Have you tried going to Windows menu and unhide. This should
allow you to access the Personal workbook. -- Sincerely, Michael Colvin "Louise" wrote: Hi all A colleague of mine has created a macro but rather than saving it into the current workbook has saved it to the personal macro workbook. It now says that the personal workbook is hidden. We have tried to delete the macro and it says it cannot find thie hidden workbook. How can I delete this macro and close the personal macro workbook??? THank you. Louise |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros - Peronal workbook
Michael
No I haven't actually, I will try that. Once I find it though, how do I get rid of it to stop it from opening each time I open Excel? I remember somebody doing this once before and it caused us endless problems. Thanks again. Louise "Michael" wrote: Hi Louise. Have you tried going to Windows menu and unhide. This should allow you to access the Personal workbook. -- Sincerely, Michael Colvin "Louise" wrote: Hi all A colleague of mine has created a macro but rather than saving it into the current workbook has saved it to the personal macro workbook. It now says that the personal workbook is hidden. We have tried to delete the macro and it says it cannot find thie hidden workbook. How can I delete this macro and close the personal macro workbook??? THank you. Louise |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros - Peronal workbook
If it is just the one general purpose macro you have stored in the Personal workbook then go to your XLStart folder which will be under the Microsoft Office folder on your hard drive and delete the workbook from there. Any macros attached to individual workbooks shouldn't be affected. That would be my suggestion, but as my signature says i'd possibly get a second opinion :) -- penri0_0 ------------------------------------------------------------------------ penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947 View this thread: http://www.excelforum.com/showthread...hreadid=542956 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros - Peronal workbook
Hi Louise, This is just an expansion on Penri's answer as he/she has hit it bang on the button - it may may it quicker than searching for the XLstart folder: * To close the personal.xls file & learn where it is stored (for deletion): Follow Penri's suggestion of unhiding [alt + w + u], check the File-Properties (ie [alt + f + i]), choose the "General" tab, read/copy the "location", close the file, go to the location & delete file if desired. Just out of curiosity, what sort of "endless problems" did you experience? hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=542956 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros - Peronal workbook
just for the record i'm a 'he' ;) -- penri0_0 ------------------------------------------------------------------------ penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947 View this thread: http://www.excelforum.com/showthread...hreadid=542956 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros - Peronal workbook
THank yo for your reply.
The problem last time was every time Excel was opened, the personal workbook was opened too by default, rather than just Book1, so we always had to close it before we started to use Excel. Louise "broro183" wrote: Hi Louise, This is just an expansion on Penri's answer as he/she has hit it bang on the button - it may may it quicker than searching for the XLstart folder: * To close the personal.xls file & learn where it is stored (for deletion): Follow Penri's suggestion of unhiding [alt + w + u], check the File-Properties (ie [alt + f + i]), choose the "General" tab, read/copy the "location", close the file, go to the location & delete file if desired. Just out of curiosity, what sort of "endless problems" did you experience? hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=542956 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros - Peronal workbook
Hi, Pleased we could help :-) Penri, I thought you were a he but didn't want to offend - the record is all good. Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=542956 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
| Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
| can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Linear Mode
