unable to use tab on protected sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vikky - 09 Feb 2007 15:03 GMT

Hi Experts;

I have a excel file with password protected sheet; I can not use tab
key on this sheet.

Is it possible that I can use tab key on a password protected sheet.

Thanks

Regards
Vikky :)

Reply to this Message

Gord Dibben - 09 Feb 2007 16:21 GMT

You can Tab to unlocked cells only.

Unprotect the sheet then select the cells you want to Tab to.

Format>Cells>Protection. Uncheck "locked".

Protect the sheet again and Tab to those cells.

Gord Dibben MS Excel MVP

>Hi Experts;
>
[quoted text clipped - 7 lines]
>Regards
>Vikky :)

Reply to this Message

Vikky - 09 Feb 2007 18:07 GMT

> You can Tab to unlocked cells only.
>
[quoted text clipped - 19 lines]
>
> - Show quoted text -

Thanks A lot Gord it's working.

Reply to this Message