Skip to Content
Former Member
Apr 01, 2009 at 09:13 AM

No variable popup in Analyzer



I have created a workbook with several tabs (each tabs have the same query but with diferent 'tasks') but I have problem : there is no popup in variable screen when I open my workbook.

In fact, there is no problem when I open query designer, I don't have errors and I can choose my 'project' but in analyzer, my workbook open directly without variable screen for 'project'. However, I can 'change variables values' when this workbook is opened.

On the other side, I have created a macro for excel to protect the sheet but it doesn't execute (I don't know why... I have to do it manually but it is an other problem). I have realized that when my workbook is protected, I can't click on 'change variables values' button, whereas when my workbook is unprotected, I can click on this button !

Thanks in advance for answers