| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to edit a macro
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to edit a macro
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to edit a macro
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to edit this Macro? | Setting up and Configuration of Excel | |||
| I know you can't run a macro while in edit mode, but... | Excel Discussion (Misc queries) | |||
| How do I edit this macro? | Excel Discussion (Misc queries) | |||
| Edit Macro 1st time use | Excel Discussion (Misc queries) | |||
| Macro to edit formula | Excel Discussion (Misc queries) | |||
Linear Mode
