CODEWITHSUNDEEP
excelmenu
Lobito
Lobito

Reputation: 147

EXCEL extend the Menu by an own section how do I this

I have a EXCEL Workbook with tables for book keeping. And a Macro to book with sevaral Subs up to now the user has to start this Macro, I want to keep away the user from the tables, to hinder him to enter data inconsistent. Is there a way to extend the horizontal menu bar by an own section. And how can I realize this.

Upvotes: 0

Views: 53

Answers (1)

teylyn
teylyn

Reputation: 35915

Three options spring to mind:

  • Use shapes or buttons in the worksheet and assign macros to these buttons.

  • You can easily add your macros to the ribbon. Create custom groups in any ribbon, or add new ribbon tabs for your macros. Then choose your macros from the command dropdown.

  • For more sophistication you can use the free add-in RibbonX Editor: https://github.com/fernandreu/office-ribbonx-editor/releases/tag/v1.8.0

Upvotes: 1

Related Questions