Protecting sheets in Excel 2003, 2007 and 2010

**kensei** · 01-14-2011, 05:23 AM

hi guys, some of you knows if in different version of excel the protection VBA code is the same ?

any differences ?

i have a class module called Data manager in which i have this function

Please Login or Register  to view this content.

and it works fine in excel 2003 but when it runs on excel 2007 and excel 2010 cause some problem in the sheet content. some chart and button changes their position when the sheet is protected.. even if theese object are linked to a specific cell...

anyone who can help me ?

bye and thanks :D

**royUK** · 01-14-2011, 05:24 AM

Protection remains the same in all versions afaik

**kensei** · 01-14-2011, 05:57 AM

Originally Posted by royUK

Protection remains the same in all versions afaik

Thanks

so using

Please Login or Register  to view this content.

is the same as

Please Login or Register  to view this content.

?

and the last thing :P how can i avoid that oject such as chart and buttons changest their porition after protection ?

thanks :D

**royUK** · 01-14-2011, 06:03 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**kensei** · 01-14-2011, 06:06 AM

done! :D

sorry i thought that for a single line could be omitted ^_^

**royUK** · 01-14-2011, 06:12 AM

We like all code snippets to be displayed with tags.

Call is used to run a Procedure or Macro, so the second line of code should work. You can declare the password as a Constant

Please Login or Register  to view this content.

I'm not sure why the objects are moving maybe attach the workbook in a new thread on that problem

**kensei** · 01-14-2011, 06:39 AM

Originally Posted by royUK

We like all code snippets to be displayed with tags.

Call is used to run a Procedure or Macro, so the second line of code should work. You can declare the password as a Constant

Please Login or Register  to view this content.

I'm not sure why the objects are moving maybe attach the workbook in a new thread on that problem

yep the pdw is delared as constant,
i posted the password directly to keep the code short :D

i posted the element position problem here i don't know if it is the correct section: http://www.excelforum.com/excel-new-...to-2010-a.html some day ago but only yesterday i start thinking that the problem could be protection ...

thanks roy