-
Taking away Excel's normal controls is a perilous path.
CommandBars is a property of the whole Application, not just your workbook.
How does the user get back their Excel functionality if
1) your code crashes?
2) Excel crashes?
3) Windows crashes?
4) their computer crashes?
How do they get their menu bar back when they switch to a different workbook without closing yours?
To answer your question, look through the properties of a CommandBar object. The obvious one will do what it says it does.
(If you cant figure out which property is "the obvious one", your code is going to hurt someone.)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules