Hi
We have an excel file that already has a custom menu build menu (like File, Edit, View etc ...) inside using some other macro that is locked. We wish to record a macro for a series of actions that involve different selections of that Custom Menu. The macro that is recorded simply is empty when recording is done. Any smart ideas to get around this ? I have tried very simple recordings just to make sure that the macro has a problem with that Custom Menu and I am 100% positive about it. It simply doesn't write anything inside the "Sub". Thanks in advance for any help.
We have an excel file that already has a custom menu build menu (like File, Edit, View etc ...) inside using some other macro that is locked. We wish to record a macro for a series of actions that involve different selections of that Custom Menu. The macro that is recorded simply is empty when recording is done. Any smart ideas to get around this ? I have tried very simple recordings just to make sure that the macro has a problem with that Custom Menu and I am 100% positive about it. It simply doesn't write anything inside the "Sub". Thanks in advance for any help.