What's the best way to execute code on a protected chart?

[skysurfer]

Hi,

I have some code that changes the axis of an embeddes chart when a user pressed a button. Trouble is, that worksheet and the chart are supposed to be password protected and the code will not work on a protected chart...it blows up.

What is the best way to have the code work and to still have the chart and sheet protected? Do I need to have code unprotect the chart first? Is that a secure thing to do?

Please Login or Register  to view this content.

Lawrence

[Palmetto]

See this link on How to run macros on protected sheets

[skysurfer]

Palmetto,

Thanks. Only problem is Mr. Excel's recommendation to place the security code in the workbook open event didn't work. Suspect it has to do with the embedded chart.

Please Login or Register  to view this content.

Or maybe I messed it up?

Lawrence

[shg]

Did you unlock the charts?

[skysurfer]

If the charts are locked, I get an error on opening the file:

"Compile error in hidden module: ThisWorkbook"

If I unlock the charts, every macro work perfectly...except that the charts are no longer protected and can be changed/deleted by the user.

Is there security code that works with charts?

Lawrence

[shg]

I can't address the compile error -- don't know what's there.

However, you can always unprotect the sheet in code, do whatever you want, and then reprotect the sheet.

[skysurfer]

Yup, that seems to be the sure bet right now. Is there any way to stop or break a macro before it's finished and before the protection is re-engaged? like hitting the escape key or something?

Lawrence

[shg]

Yes, via the Esc key, or via Ctrl+Break.

If secure is what you're looking for, Excel is not your animal.