Good way to have same text show on every worksheet without regard to column width?

Vote count:

0

I have 10 worksheets in a workbook.

In every worksheet in this workbook I want to enter customer, project name and project manager in a certain position. These values are the same in att sheets.

Ideally I want the user to enter these details into one "admin sheet" and then have that information show in all sheets with no regards to their column widths.

What is a good way of doing this?

I have considered entering a text box into each of the 10 worksheets. But that has at least two drawbacks

• Users might accidentally select and move the text boxes and become confused and annoyed


• I have to have some kind of VBA worksheet change events that update the checkboxes when users change the project manager, client or project name in the admin sheet. This feels unnecessarily complex.

Is there a better way?

asked 1 min ago

user1283776

705

Good way to have same text show on every worksheet without regard to column width?