Possibly Just protect content.

If you have linked cells, then make sure they are unlocked.

--
Regards,
Tom Ogilvy

"John" <John @discussions.microsoft.com wrote in message
...
i am after information on allowing scroll bars and option buttons to work
when the excel document is locked any ideas anyone