Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dabile
 
Posts: n/a
Default Not allow certain cell entries

I have a worksheet setup with 5 tabs. On 3 of the tabs I do not want to be
able to type "123" into any of the cells. Can I write a pop-up or function
for these three tabs within the worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default Not allow certain cell entries

You have a WORKBOOK with five WORKSHEETS
Each worksheet has a tab for opening it.
If you group the three worksheets together (Help will tell how), then what
you type in a cell in one will also be entered into the corresponding cells
in the other worksheets.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dabile" wrote in message
...
I have a worksheet setup with 5 tabs. On 3 of the tabs I do not want to be
able to type "123" into any of the cells. Can I write a pop-up or
function
for these three tabs within the worksheet?



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
Excel: Clear all cell entries EXCEPT formulas? newsgal Excel Discussion (Misc queries) 6 March 18th 06 12:46 AM
How do I get entries over 1000 characters to display in a cell? Mike in Berkeley Excel Discussion (Misc queries) 3 September 11th 05 10:08 PM
Identify repeated cell entries in multiple sheet workbook as you . Trigger Excel Discussion (Misc queries) 0 August 17th 05 01:57 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Automatic changes in cell entries doco Excel Discussion (Misc queries) 3 December 12th 04 04:23 PM


All times are GMT +1. The time now is 10:25 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"