LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

You can hide all those columns by:

Edit|Goto
type in o1:iv1
format|column|hide

Another option is to unlock the cells you want the user to be able to change
(format|cells|protection tab|uncheck lock).

Then protect the worksheet (tools|Protection|protect sheet)

Then tabbing will only go to those unlocked cells.

(But lots of features will be disabled in protected worksheets.)

TL wrote:

Thank you for your help, however there are too many columns to hide after
colun N and I am not familiar with running macros. Is there an easier way to
stop the tab from going past the margins of my invoice?

"TL" wrote:

I have an invoice created in excel that I would like to be able to tab over
no further than the end of the invoice(column N) and then return to column A.
Howeer, the tab continues past the column and I don't know how to lock it.


--

Dave Peterson
 
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



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

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

About Us

"It's about Microsoft Excel"