LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default Deleting Macros in Personal XLSB file

You can open the Macro Dialog Box by clicking ToolsMacroMacros on the menu
bar. Then click the particular macro name that you want to delete and click
delete.

Or you could just open the Visual Basic Editor with Alt + F11, use the mouse
to select the code module, Module1, ThisWorkbook, Sheet1, etc. where the
macro resides, then select the body of code with the mouse and press the
delete button on the keyboard.

There's more, but I think that either of these two will get the job done.


"tgreenwood" wrote in message
...
Sorry, but that still does not answer the question. The extent of my macro
knowledge is to click on create macro, assign a keyboard or toolbar
shortcut
to it, and "teach" Excel which task I want to automate (usually repetitive
tasks that require way too many mouse clicks.

Since I messed up that, I want to delete the macro and start over again.

Is there any way to do that? I do NOT want to try to edit the macro
because
it's way beyond my area of expertise.



 
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
personal.xlsb dhstein Excel Discussion (Misc queries) 2 June 24th 09 11:20 AM
personal.xlsb file Alain Excel Discussion (Misc queries) 1 November 4th 07 11:02 AM
hide personal.xlsb file without closing Terry Excel Discussion (Misc queries) 3 July 21st 07 07:08 AM
Excel 2007: deleting macro from personal.xlsb Carl LaFong Excel Programming 10 April 30th 07 04:37 AM
Deleting macros that are available in personal.xls! aiyer[_15_] Excel Programming 2 April 16th 04 05:21 PM


All times are GMT +1. The time now is 05:53 AM.

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

About Us

"It's about Microsoft Excel"