ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Not allow certain cell entries (https://www.excelbanter.com/excel-worksheet-functions/57996-not-allow-certain-cell-entries.html)

dabile

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?

Bernard Liengme

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?





All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com