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é

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


http://groups.google.ca/groups?&thre...2s %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