Hi All,
Not sure if I accidentally changed a setting but now when I open a module I dont see any of the subs under general I have to select individual subs in the left hand dropdown to see them.
If I have messed something up can someone point me where to change it back?
Second question with businesses moving to Teams/Sharepoint hosting of excel files a lot of my vba is no longer working does anyoine have any idea if we will get back the functionality we're losing?
regards
John
I suspect you've unchecked the 'Default to full module view' option in Tools - Options - Editor tab, Window Settings section?
Your second question is a bit vague (to me anyway). What functionality specifically?
Ahh thank you, dont recall changing that.
Functionality like running a script from an event on close/open cell change selection change, userforms etc etc
Power Automate and flows are not an option because my business has decided that it will cause too many issues with Flow ownership and colleagues leaving business (like vba doesnt already do that 🙂 )
As ong as you open the files in the desktop version, the VBA will work. If you have it open in the online version of excel (which is also what teams uses) then VBA will not work, and that will not change. You would have to migrate to other options like office scripts and flow.
