FilterViewUID

[Sinister]

I am trying to write some code that will disable the filter menu item and I
was wondering if anyone knew if this property will do that.

Thanks,
Patrick

 

[John]

I am trying to write some code that will disable the filter menu item and I
was wondering if anyone knew if this property will do that.

Thanks,
Patrick

Patrick,
Since this is a question about programming, it should be posted to our
sister newsgroup, microsoft.public.project.developer. However, using
normal VBA, there is no such property or method. It might be possible
with an API or with separate Visual Basic code but I have no idea how it
could be done.

To satisfy my curiosity, why do you want to disable a menu item? If you
are trying to keep users from using it, I suggest your best, and perhaps
only, approach is training.

John
Project MVP

 

[Jack Dahlgren]

The following code removes it from the menu:

CommandBars("Project").Controls(2).Delete

Code for removing it from toolbars can be deduced using the macro recorder.

I do not think that it is possible to remove the keyboard shortcut, but most
people don't know it anyway.

In response to John, I put together a demo which stripped the project
interface down to 6 buttons. It was very simple and intuitive. People liked
it. The current UI is too complicated and provides little guidance about what
the correct procedure is for building or updating a schedule.


-Jack Dahlgren

 

[John]

The following code removes it from the menu:

CommandBars("Project").Controls(2).Delete

Code for removing it from toolbars can be deduced using the macro recorder.

I do not think that it is possible to remove the keyboard shortcut, but most
people don't know it anyway.

In response to John, I put together a demo which stripped the project
interface down to 6 buttons. It was very simple and intuitive. People liked
it. The current UI is too complicated and provides little guidance about what
the correct procedure is for building or updating a schedule.


-Jack Dahlgren

Jack,
Thanks for enlightening me. I should have given it a little more thought
or done some research before I responded. My bad.

John

 

[Sinister]

Perfect. That should work nicely. Thanks

Long story short I'm going to load a filter that is dependent upon what
department the person belongs to. I don't want them to be able to change the
filter once in.

 

[John]

Perfect. That should work nicely. Thanks

Long story short I'm going to load a filter that is dependent upon what
department the person belongs to. I don't want them to be able to change the
filter once in.

Sinister,
Sorry for my incorrect original response. If I had thought for a few
seconds more, I would have realized that I did something very similar
several years. I needed to create a custom button for some macros to be
used by our cost account managers (CAM). I wrote an auto-open macro that
added a custom toolbar with the button and macro code behind them to
each of the CAM files.

Yeah to Jack for steering you in the right direction.

John
Project MVP

 

[Sinister]

Everybody has been extremely helpful. Totally appreciate it.

Does anyone know the event for when a user expand and contracts a summary
task?