disable Menu/toolbar items

G

Guest

How do I disable Menu / toolbar items when opening a workbook and enable them
when I close the workbook. Doing this to force the user to use the macro's I
have written.
 
G

Guest

Application.CommandBars("Tools").Enabled = False

The above placed in the workbook open event will disable the Tools menu.

Application.CommandBars("Tools").Enabled = true

And this placed in the before-close event will re-enable it.

You could in this way disable others by changing Tools to Format for example
but it seems a bit drastic to me.
 
G

Guest

Hi Mike,

I basically want to disable the print function in the toolbar as well as the
menu and the save / save as buttons.
I did this years ago and just can't rember how to do it again. Do I create a
open event SUB and give the command?

Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing Macros to Run 2
Avoid using macro's from other workbook(s) 1
Disable Menu Items 2
wildcard in filenames in macro 9
manually run macro's 3
Buttons re-assigned themselves to the right macro name but in Book 1
Close Workbook If user disables macro's 6
Problem with workbook on_open event 1

Top