Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 76
Default Protect Sheet Quest.

One prblem I am having is when I protect my
sheet so the data entry people to not type out
my formula form the cell.
One problem. It will not let them tab to the next
the adjacent cell. it seem the tab button does not
work at all.
Please advis e
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default Protect Sheet Quest.

As I recall, when a sheet is protected and you use the tab key you will be
taken to the next UNlocked cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dylan @ UAFC" wrote in message
...
One prblem I am having is when I protect my
sheet so the data entry people to not type out
my formula form the cell.
One problem. It will not let them tab to the next
the adjacent cell. it seem the tab button does not
work at all.
Please advis e


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 76
Default Protect Sheet Quest.

no its not working like that, or least for me.
Easy solution is "use the arrow key"
but they have the tab key.
Any advise would help

"Don Guillett" wrote:

As I recall, when a sheet is protected and you use the tab key you will be
taken to the next UNlocked cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dylan @ UAFC" wrote in message
...
One prblem I am having is when I protect my
sheet so the data entry people to not type out
my formula form the cell.
One problem. It will not let them tab to the next
the adjacent cell. it seem the tab button does not
work at all.
Please advis e



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Range quest. N.F[_2_] Excel Discussion (Misc queries) 0 August 17th 07 02:14 AM
Sum Product Quest: include an OR? nastech Excel Discussion (Misc queries) 4 August 14th 06 07:40 PM
Protect Workbook Vs Protect Sheet Poor_pakistani New Users to Excel 4 May 25th 06 02:06 PM
Can I protect columns w/in a "List" using Protect Sheet? Diane Excel Discussion (Misc queries) 0 May 10th 06 03:30 PM
My Quest with Time!! Philip Excel Worksheet Functions 4 August 24th 05 01:09 PM


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"