![]() |
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? |
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