View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how to edit a macro

Daniel

Is the workbook shared under ToolsShare Workbook?

Is the VBAProject locked for viewing?

Hit Alt + F11 to go to VBE and double-click on your workbook/project.

Any message or does the module open for editing?


Gord Dibben MS Excel MVP

On Mon, 10 Dec 2007 16:32:03 -0800, Daniel
wrote:

I created a macro and now want to edit.
When I click the name the 'edit' is now highlight or dim, not function
I changed the security level to low and not help
Need your help
THanks
Daniel