Log in

View Full Version : [SOLVED:] VBA View Object panel inaccessible



msstein
09-09-2023, 04:52 AM
Hello, i'm following a tutorial to setup Application events from Use Events with the Application Object | Microsoft Learn (https://learn.microsoft.com/en-us/office/vba/powerpoint/how-to/use-events-with-the-application-object).

There's a section on that tutorial that said

"After the new object is declared with events, it appears in the Object list in the class module, and you can write event procedures for the new object. (When you select the new object in the Object list, the valid events for that object are listed in the Procedure list.)"

But when i go check my VBA Window, i found out that the "View Object" button is greyed out alongside the View > Object (Shift+F7) on the menu.

What did i do wrong?

msstein
09-09-2023, 05:00 AM
https://64.media.tumblr.com/d06914156caba4e7840993b7430dd0a0/79582b56b41dc541-e4/s400x600/3a0d589484e5b2a6950dec060d80f4c8709c289b.pnj

Aussiebear
09-09-2023, 06:19 AM
Welcome to VBAX msstein. Have a look here https://answers.microsoft.com/en-us/msoffice/forum/all/visual-basic-button-in-excel-greyed-out-office-365/c7017329-0518-4618-8c3d-6f799779338e?page=2.

msstein
09-09-2023, 07:08 AM
Hello Aussiebear, thanks for the reply, the linked discussion seems about them not being able to use Visual Basic at all, mine worked all right but it's only the 'View Object' panel that inaccessible.

Anyway, I'll try out the steps on the linked discussion to see if it helps

Aussiebear
09-09-2023, 01:32 PM
When I tried it last night I had the same result, so I thought maybe I'd missed something. So I downloaded a workbook from PaulKelly on Class Modules and its does the same thing. Perhaps its a MS thing.

msstein
09-09-2023, 07:53 PM
It might be yes.

I did some digging last night and ended up with this workaround to access all the events from an object using the procedures list
https://64.media.tumblr.com/49a76ebafa45ef1618cdf60692c04354/452f03def29cb79d-54/s1280x1920/2cafef513e2d42097b0d12c9963cbfb3cfcbf88a.pnj

Maybe there's more stuff on the View Object panel that aren't on the procedures list but this will do for now, thanks.