Lock and unlock page within viewode

Greetings,

Is there a way to unlock a page, run a page macro, then lock it again, all within a sheet view code?

I currently have the code working perfectly whenever the sheet becomes active, but would like to protect its contents while it’s open unless I manually unlock it

If I lock it and scroll away then back, I get an error code.

Thanks

It's not clear (to me at least) what exactly you mean.

You have working code that runs when you activate a sheet? Then why do you need to unprotect the sheet at all?

Beth.

Because the data is being populated from another sheet, I wish to prevent someone from making changes in the sheet, it’s more of a double security and makes sure work is not done or wasted in the wrong area......

But if I manually lock those sheets, then navigate away, then back.... I get a debug error.

I am trying to make it more user simple..... I might be asking too much of the program, but the vision is correct

Could you not have code unprotect the sheet, do what it does, then reprotect the sheet? That way it wouldn't be unprotected long enough for anyone to make any changes.

Or, you could set the protection on the sheet with the UserInterfaceOnly property set to True during the workbook open event. That way the code can manipulate the sheet but the user cannot.

It would be easier to give a more specific answer on the debug error if we knew what the code was, or even better if we could see the file (a desensitized version of).

Beth.

That’s what I want, but when I’ve tried writing the code to booked the working code, I get an debug error

And if you show us the code / file, perhaps we can help with that debug error...

Beth.