On screen forms - How do I get Excel to ignore unused cells? 
Author Message
 On screen forms - How do I get Excel to ignore unused cells?

I've created an on screen form, and I want the operator to be able to
enter data in a specific cell, press Enter, and then move automatically to
the next specific cell, ignoring the unused ones in between.

Can it be done?

--
Posted via CNET Help.com
http://www.*-*-*.com/



Wed, 18 Jun 1902 08:00:00 GMT  
 On screen forms - How do I get Excel to ignore unused cells?


Quote:
> I've created an on screen form, and I want the operator to be able to
> enter data in a specific cell, press Enter, and then move automatically to
> the next specific cell, ignoring the unused ones in between.

> Can it be done?

Yes, it can....

First, make sure the cells where the user is supposed to enter data are
unlocked (and all others are locked), then protect the sheet (password
optional). The final step is to include this in the Workbook_Open event
code:

    Worksheets("Formsheet").EnableSelection = xlUnlockedCells
    ' using the name of your worksheet, of course

George



Wed, 18 Jun 1902 08:00:00 GMT  
 On screen forms - How do I get Excel to ignore unused cells?
What is an Workbook_Open event code ?

Best regards,
Edwin

* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping.  Smart is Beautiful



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Problem with tabs - goes screen to screen rather than cell to cell

2. getting values form two cells so both values show in one cell

3. Getting rid of Unused/Wanky Modules

4. How to have Excel ignore HTML tags in a cell

5. Please help with excel chart ignoring text cells

6. Can't get Excel to ignore blank cells

7. Getting a mail-form to open full-screen from HTML page

8. find first unused cell in a column

9. Can you hide all unused cells

10. Hide unused cells


 
Powered by phpBB® Forum Software © phpBB Group