Viewing LOCKED cells

[AC_VID]

Sorry, the title was not exact in previous post.

Is there a way to view LOCKED CELLS on a worksheet after the worksheet is
protected?
Could there be a macro created so that I can use for example ALT+L to view
these cells temporarely and then press ESC to go back to normal bview? This
could be in a temporary formatting of these cells in a different background
color.
This would be a very handy way to quickly make sure that the required cells
are locked when creating a worksheet with locked cells. There is another
way, which is using TAB to jump from one locked cell to another but it is
time consuming.
That function does not exist in Excel : TOOLS/Options/Window options.

Thank you
André

[Debra Dalgleish]

Gord Dibben posted code in the following thread that you could use:


http://groups.google.ca/groups?&thre...u12s%404ax.com

AC_VID wrote:
> Sorry, the title was not exact in previous post.
>
> Is there a way to view LOCKED CELLS on a worksheet after the worksheet is
> protected?
> Could there be a macro created so that I can use for example ALT+L to view
> these cells temporarely and then press ESC to go back to normal bview? This
> could be in a temporary formatting of these cells in a different background
> color.
> This would be a very handy way to quickly make sure that the required cells
> are locked when creating a worksheet with locked cells. There is another
> way, which is using TAB to jump from one locked cell to another but it is
> time consuming.
> That function does not exist in Excel : TOOLS/Options/Window options.
>
> Thank you
> André
>
>
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html