Not allow certain cell entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top