View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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?