V
V
Vyacheslav Grachunov2019-03-16 20:12:07
Visual Basic
Vyacheslav Grachunov, 2019-03-16 20:12:07

Made myself a problem with Excel. Menu doesn't work. How to decide?

Executed the following code to temporarily deactivate the panels (it was necessary for the VBA application)

With Application
    For Each iCommandBar In .CommandBars
        iCommandBar.Enabled = False
    Next
End With

Moreover, on closing the file on the Workbook_BeforeClose event, I hung the same thing with True - after closing this book, the right-click menu does not work. It starts working only if you execute this code after opening.
What to do? How can I get it back to work right away?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vyacheslav Grachunov, 2019-03-17
@Qwentor

I ran the same thing once with True via Personal.xlsb at startup via Workbook_Open - and everything became ok, then the event was deleted and everything works. Geez what was that.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question