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

Please Login or Register  to view this content.

'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.

If you have a question, please start your own thread. You can include a link to this thread if appropriate.

As a newcomer to the forum, please take the time to read the Forum Rules.