Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Deleting Personal.xls macro


Can someone please help me. I am stuck with this frustrating macro.
Every time I have a workbook open and I go to open another workbook, a
warning pops up saying this is read only due to personal.xls.

I tried to create a personal.xls macro one time, and don't even
remember what sheet it is in. I may have already deleted, I don't
know. Is there anyway to clear all personal.xls macros so there is
none.

Thanks for any help

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=467695

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,092
Default Deleting Personal.xls macro

From Windows Explorer search for all files named Personal.xls. Then delete
them.

Mike F
"jhahes" wrote in
message ...

Can someone please help me. I am stuck with this frustrating macro.
Every time I have a workbook open and I go to open another workbook, a
warning pops up saying this is read only due to personal.xls.

I tried to create a personal.xls macro one time, and don't even
remember what sheet it is in. I may have already deleted, I don't
know. Is there anyway to clear all personal.xls macros so there is
none.

Thanks for any help

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=467695



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default Deleting Personal.xls macro

Close Excel, use windows explorer to find the file called PERSONAL.xls.
You can then delete the file or move it out of the XLSTART folder if you
wanted to be able to recover it.

Hope this helps
Rowan

jhahes wrote:
Can someone please help me. I am stuck with this frustrating macro.
Every time I have a workbook open and I go to open another workbook, a
warning pops up saying this is read only due to personal.xls.

I tried to create a personal.xls macro one time, and don't even
remember what sheet it is in. I may have already deleted, I don't
know. Is there anyway to clear all personal.xls macros so there is
none.

Thanks for any help

Josh


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro runs in source , but not when in Personal Macro Workbook Darin Kramer Excel Programming 1 September 13th 05 04:48 PM
Personal macro workbook and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM
Deleting macros that are available in personal.xls! aiyer[_15_] Excel Programming 2 April 16th 04 05:21 PM
personal.htm & personal.xls in Macro Rasoul Khoshravan Azar Excel Programming 0 January 21st 04 05:27 PM


All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"