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