Hi all
My first post and hopefully you have some guidance and way to solve my problem within Excel
Just installed windows 8.1 which I have never used before and then installed office 2007 Enterprise via a C/D that I have used
with windows XP and 7 Pro and had no problems with them
I have some templates I did way back in 2003, they have worked with no issues Office 2007 on those XP and win 7 P/Cs
Templates are complex in that there is like 20 sheets, 3 are data sheets and the others are charts.
These were made mostly in recording while using the Excel program
Also has one MACRO
Templates were saved as type using MACROs
Loading a template on Win 8.1 in Excel 2007 the one MACRO works but none of the VBA objects
None of the VBA functions work and no type of errors appear
I turned off MACRO security protection and checked marked to allow VBA in Excel options and still VBA not working
I checked in Add-Ins of Excel and the one for VBA is installed
I checked trusted sources in Excel options and use of VBA is checked
Via Excel I can click on VBA ICON, it does bring that screen up and all the objects for VBA of template show there but even clicking on run the only process that works is the 1 MACRO
Why are my templates working just fine also using office 2007 in XP and win 7 but not on this P/C using windows 8.1 ?
What am I missing and how to debug and solve this as I really need those templates fully functional ? ?
vba.jpg
Many Thanks, JR
Bookmarks