Hi Guys
I m not able to enable VBA in excel 2007. Plz anybody help me regardin my issue, i will highly appriciate.
Help to enable VBA in excel 2007
Hi Guys
I m not able to enable VBA in excel 2007. Plz anybody help me regardin my issue, i will highly appriciate.
I believe you need to click on the Office Button (top left) and then go to "excel Options" tab at the very bottom of the window that came up. Check the Developer Ribbon. This should do the trick
I have done it but still visual code button not active.
Alt-F11 will switch between the worksheetand the VBA editor
Does that work?
Paul
No It does not work. This problem is happining only few day before this its work. And when i open any VBA file it give error "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.
" and also it give a link where i click then it give error "plz give any suggetion
attach Your workbook to check it.
Somethings to try,
On the Developer tab, go to "Macro Security"
1. On "Macro Settings", select "Disable macros with Notification", and then check mark "Trust access to the VBA Project Object Model"
2. On "ActiveX Controls", select "Prompt Me" and then check mark "Safe Mode".
3. Otherwise, the installation options or group policy policy might need to be changed. Look at
"Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel"
http://support.microsoft.com/kb/282847
Paul
Posting Permissions
Reply With Quote
