PDA

View Full Version : Help to enable VBA in excel 2007



online
09-17-2009, 12:07 PM
Hi Guys
I m not able to enable VBA in excel 2007. Plz anybody help me regardin my issue, i will highly appriciate.

leal72
09-17-2009, 01:17 PM
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

online
09-17-2009, 02:50 PM
I have done it but still visual code button not active.

Paul_Hossler
09-17-2009, 03:54 PM
Alt-F11 will switch between the worksheetand the VBA editor

Does that work?

Paul

online
09-19-2009, 10:09 PM
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

hardlife
09-20-2009, 04:37 AM
attach Your workbook to check it.

Paul_Hossler
09-20-2009, 07:41 AM
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