I have a page that opens on startup. It contains a NEW EMPLOYEE and a SEARCH/UPDATE button. In addition, I am using 5 separate Command Buttons which, when clicked, will bring the user to 1 of 5 different sheets. The sheets are currently named "Duty Ofc 1", "Duty Ofc 2", etc but they will likely be changed to each Duty Officer's name. Is it possible to automatically change the Command Button caption to reflect if/when the name of each individual sheet changes?
Bookmarks