View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Showing which cells are locked

There is no facility to select all of the unlocked cells or such. What you
can do is to put the lock icon onto one of your toolbars...

Tools - Customize - Commands (tab) - Format - Lock Cell (icon about 3/4
the way down the list) - drag it to your toolbar...
--
HTH...

Jim Thomlinson


"smithista" wrote:

Is there a way to show which cells in a worksheet are locked?

Thanks
Stephen