Hi, I have made this really cool excel file for my D&D campaign (at this time, you may download it to check it out, but please do not use for commercial purposes). I am not gifted when it comes to programming, but I have been searching for a way through VBA that's easy to have this load exactly as I want it every time I open the file. Unfortunately, I think I'm in over my head here. The way I want the file to open is in full screen mode (No ribbon or anything else that may get in the way of seeing the data) and to be able to visually see columns A-F and rows to 26 stretched out on the entire screen. I want to be able to edit cell text while in this mode as well as be able to copy and paste using the keyboard macros for the cell located at in row 26 that says "Active Turn -." I also need to be able to sort the last column (F) at any time from greatest to smallest without it being too much trouble. For those of you checking out my tool, the way it works is you copy the active turn cell text and paste it into column A for the row whose turn it is in the initiative. It will highlight the entire row. It works beautifully. And now that you see it - I hope you see how essential it is to make it display properly. Any help would be greatly appreciated. In the minisheet, I have included the last three rows (Rows 23-26).
| Initiative Tracker.xlsx | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 24 | NPC/Monster | TBD | 0 | 0 | ||||
| 25 | NPC/Monster | TBD | 0 | 0 | ||||
| 26 | Active Turn ➤ | CTRL + SHIFT + F1 for full screen | ||||||
Initiative Tracker | ||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| B2:XFD2,3:8,B9:XFD9,10:25 | Expression | =$A2="Active Turn ➤" | text | NO |
