cancel
Showing results for 
Search instead for 
Did you mean: 

Workook problem

Former Member
0 Kudos

Hi All,

After opening the Workbook when I try to click on chart,filter and information.I am getting error :" cannot run the macro ZRD_ZCOMD1.xlsx!sheet2.Graph_click'.The macro may not be available in this workbook or all macros may be disabled.

Let me know you valuable inputs.

Regards,

Madhavi

Accepted Solutions (1)

Accepted Solutions (1)

michael_devine
Employee
Employee
0 Kudos

Hi,

To resolve this, click the button 'Switch to Design Mode' and then 'Swich to Analysis Mode'(Toggle). This will re-enable the macros (you can check this in VBA editor by pressing alt+f11) and you can use the buttons as usual.

Thanks,

Michael

Former Member
0 Kudos

Hi Miche,

I can't see the analysis mode.please let me know where I can find that option.

Regards,

Madhavi

Edited by: madhavi on Oct 14, 2010 6:13 PM

Edited by: madhavi on Oct 14, 2010 6:14 PM

michael_devine
Employee
Employee
0 Kudos

Hi,

Once you are in design modea, just click the design mode button again and the workbook will convert back to analysis mode.

Does this work?

Thanks,

Michael

Former Member
0 Kudos

Hi,

I tried but no luck.Can we do it in any other way around.

Thanks

Madhavi

Answers (0)