How to disable the File-Print menu? 1

[kev747]

Hi all,
I need to disable the File menu Print option in my database. This is because some users who want to print out a single report, select the File menu Print option, and print out all reports in the db.
Is is possible to lock this option out of the File menu?

Many thanks in advance.

Kev.

 

[grtammi]

Go to Tools->Startup, and de-select allow full menus.

Boss quote from an office meeting: We're going to continue to have these meetings until we figure out why no work is getting done ...

 

[kev747]

Hey grtammi,
This is the first thing I tried, and while it removes the Print icon from the toolbar, the Print option still remains in the File menu, as does the Ctrl + P print option.

Any other ideas?

Kev.

 

[TonyJollans]

Hi kev747,

To disable the menu option ..

Application.CommandBars("Menu Bar").Controls("File").Controls("Print...").Enabled = False

Enjoy,
Tony

 

[kev747]

Thanks Tony, works a treat.
Have a star.

Kev.