Macro will not work when sheet is Protected

Hi there guys, this is a followup to the same spreadsheet used in the following thread:

http://www.excelforum.com/showthread...92#post1933992

Hey guys, i have a question for the experts.

I want to use Protection on this sheet to prevent the user from entering data in any spot, except for a few places.

Unfortuntely, when I turn on the protection, the macro will not run. Is there anyway to have my sheet protected and let that macro run? Or am i forced to turn off protection and hope noone messes up the sheet? I already tried specifiying that sort and auto filter can be used by the user(by checking those check boses under Protection) but this did not solve issue

Thanks

See Help for the UserInterfaceOnly argument for the Protect method.

Why not just have the protection turned off while the macro runs and the last line of code turns it back on

Sub pwd
ActiveSheet.UnProtect Password:="Password"

"your code"

ActiveSheet.Protect Password:="Password"

end sub

'Something like that...

Thanks for the help on this one. Sorry for such a easy question!

Sorry for such a easy question!

That's where all of us began ...

I'm new to these forums, and VBA in excel (but not VB in general).

But, I'm wondering how the macro is going to run, and thereby disable protection, in the first place.