Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Macros in Personal XLSB file
I want to delete and edit some macros I have created. I saved them to my
personal.XSLB file. So, whenever I tried to edit or delete the macros, I get the following error: "Cannot edit a macro in a hidden workbook. Unhide the workbook using the Unhide command." I seem to be unable to perform the suggested action. Does anyone know how to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Macros in Personal XLSB file
Hi Kevin
No need to unhide the file Alt F11 to open the VBA editor Change the code in the modules and save the file in the VBA editor Alt q to close the VBA editor -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kevin" wrote in message ... I want to delete and edit some macros I have created. I saved them to my personal.XSLB file. So, whenever I tried to edit or delete the macros, I get the following error: "Cannot edit a macro in a hidden workbook. Unhide the workbook using the Unhide command." I seem to be unable to perform the suggested action. Does anyone know how to do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Macros in Personal XLSB file
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
personal.xlsb | Excel Discussion (Misc queries) | |||
personal.xlsb file | Excel Discussion (Misc queries) | |||
hide personal.xlsb file without closing | Excel Discussion (Misc queries) | |||
Excel 2007: deleting macro from personal.xlsb | Excel Programming | |||
Deleting macros that are available in personal.xls! | Excel Programming |