getting error 70 permission denied on userform

[kevinu]

I found out how to put graphs on a userform and used their code. But when I run the macro i get a error 70. I followed the code progression and it errors at

Please Login or Register  to view this content.

If i run program as admin it works but I dont want to have to do this if possible. Here is all the code just in case its helpful. Any ideas how to get it to work without admin permission?

Please Login or Register  to view this content.

[davesexcel]

Sometimes the dreaded permission error occurs when you have set a controls properties in the controls properties window, and also trying to programmatically change the same control.

[kevinu]

I tried to reset all properties and settings but no luck. Is there a expert trick to debugging this? All I can see is its bugging when it tries to save the graph as a pic.

[davesexcel]

You may have to supply a sample in order for somebody to step through the code.

[rorya]

I'd suspect it's the User Account Control stopping you from writing to the root of C: - try writing to the folder the workbook is in.

[kevinu]

great. Here is a copy that has the same issue. It has to be macro enabled.

[davesexcel]

@rorya suggestion is most likely the correct one.

Change to this.

Please Login or Register  to view this content.

[kevinu]

that was it... thx