catch a event - OnAction...

[leshem]

Hi, Good Morning.
maybe someone will have an Idea for the following:
I have a protected worksheet. I am trying to draw a chart on it , so after the whole flow of DialogBoxes I get an Error Message says: you can not create a chart on a protected sheet. for Unprotect use Tools--> ...etc.
I have succeeded to remove the protction by:
CommandBars(1).Controls("C&hart...").OnAction = activesheet.unprotect
Now I need to protect the sheet again when the action is ended, the chart is drawn.
How can I protect the sheet again right on the end of the action, only by Code?

Thanks for your Quick answer.....

 

[Ivan F Moala]

On 2002-10-14 05:35, TsTom wrote:
Thanks Ivan...
What other use for the xlDialogChartWizard constant id it cannot be shown?
Tom

Yes ??!! I'm at a loss why have it.

 

[leshem]

Thank you all guys for your help.
You Sure helped me a lot.

 

[Andrew Poulsom]

Tom/Ivan,

The show method only works with xlDialogChartWizard if a chart is active. It's not the same as the dialog for adding a chart, which I cannot find in the Dialogs collection. Try it and you will see what I mean.

 

[leshem]

On 2002-10-14 09:04, Andrew Poulsom wrote:
Tom/Ivan,

The show method only works with xlDialogChartWizard if a chart is active. It's not the same as the dialog for adding a chart, which I cannot find in the Dialogs collection. Try it and you will see what I mean.

Hi Andrew,
Sorry to tell you but I couldnt find the Dialog for adding a chart in the collection either because it does not exists there - as far as I know. you can reach every step of the chart creation dialog by itself but not the whole flow together (which normally include 4 steps - 4 different Dialogs).

this is the practical reason for sticking on the Chart option from the menu and not creating this function allown, which is also the reason for needing the Protect/Unprotect answer in the first place (if you will look at my topic 1st presented).

Also, nice to here that someone else have found it besize myself, meaning it is a buildin problem of the Excel, as I see it.

 

[Ivan F Moala]

On 2002-10-14 09:04, Andrew Poulsom wrote:
Tom/Ivan,

The show method only works with xlDialogChartWizard if a chart is active. It's not the same as the dialog for adding a chart, which I cannot find in the Dialogs collection. Try it and you will see what I mean.

thanks Andrew......I thought there was alogical reason....don't really use this myself...