Hi
I have sheet 1 which is populated by lookups to another two sheets. There are four macro buttons on sheet 1 and this works fine. When I protect the sheet, I get runtime error 1004, Cannot use this command in a protected sheet. Problem is other users of the sheet have altered some of the formula and I need to stop that. Is there anyway to do so.


Also is there any way to freeze the macro buttons on top and in position when scrolling around the worksheet
Thanks
Ernie

Hello
please post in the right forum in the future. Thanks

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Apologies, I was sure I had selected Excel Forum
Ernie