Excel 2010 VBA Tutorial 109 - Customising all Excel Menus

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

Hey Matt!

Thanks a lot for the videos, awesome content!

I have made a *slight mistake and wonder if I could reverse it. As I practiced linking macros to command bars I noticed that even though the codes may not fully work, empty blocks appear in the command bar that did not disappear even when I deleted the tag I gave to the original macros. So I thought they would not have any tags and came up with the following way to delete them:


What happened is that I lost the full cell command bar and not only for the particular workbook but for the whole excel :D

Even though I did not save the workbook and deleted the code, the cell command bar is still gone. Is there any way to set it back to default?

Also, is there any way to apply the right-click macros for the given workbook only?
( I noticed for instance that this does not work:
    Dim commandM As CommandBar
    Set commandM = )

Thanks a lot for your help and I wish you all the best!

jack