Sheet or workbook protection should not prevent you from editing macros.


Gord

On Mon, 10 Dec 2007 17:02:00 -0800, Daniel
wrote:

Thanks Gord Dibben

The worksheet was protected and I forgot that
Daniel

"Gord Dibben" wrote:

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