View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Protecting an Excel worksheet without locking the embedded scrollbar

R-click the scroll bar, Format Control, Protection, UNcheck "Locked"

Genesis wrote:

Hello all,

I was able to embed a scrollbar into an Excel worksheet. I would like
to protect this worksheet and only allow certain cells to be modify. I
know how to do that BUT, every time I protect the sheet, it also locks
the embeded scrollbar so that I can't slide it anymore. Any thoughts,
comments, suggestion?

Lee