PC Review


Reply
Thread Tools Rate Thread

Disabling Certain Menu Items According to User Group

 
 
Brian Smith
Guest
Posts: n/a
 
      4th Nov 2005
I want to able to keep existing menus intact as much as possible but I'd
like to disable certain items for people in some user groups. In particular,
I'd really like to block off access to the three items under Tools--Analyze
(Table, Performance and Documenter). Is something like this possible? I've
been searching the Help files and Google and can't seem to find any
discussions on the topic but it's possible I'm using the wrong search terms.

Thanks.

Brian


 
Reply With Quote
 
 
 
 
TC
Guest
Posts: n/a
 
      5th Nov 2005
The CommandBars collection lets you get at the various toolbars. The
Enabled property of the CommandBar object lets you disable or re-enable
an option on a toolbar.

But personally, I would not manipulate the standard toolbars, if I
could avoid it. Instead, create your own toolbar(s) containing just the
options you want.

All of this is described under relevant terms in online help.

HTH,
TC

 
Reply With Quote
 
TC
Guest
Posts: n/a
 
      5th Nov 2005
Maybe you need FindControl as well - I don't have Access here to check.

HTH,
TC

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with disabling items in the menu Les Microsoft Excel Programming 6 7th Apr 2007 07:24 AM
Disabling menu items? Andy Microsoft Access VBA Modules 1 30th Dec 2003 01:14 PM
Disabling use of menu items - How? Brian Microsoft Excel Setup 0 27th Oct 2003 08:03 AM
Disabling menu items in VBE Michael Singmin Microsoft Excel Programming 1 10th Oct 2003 01:39 PM
Start Menu Items Based on User Group bsma1 Windows XP Embedded 8 29th Sep 2003 05:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:08 AM.