Greetings all. I have searched online and within the forum and had no luck.
When create a new sheet, it defaults to Left of existing. I want it to default to Right of existing, but cannot find anything in Tools>options, on google or in the forum. Does anyone know if this is possible, and how to do it?
Hallo
for english GUI:
Alt s s enter doesnt fit?
respectivly for german GUI:
Alt t a enter
No, that inserts a new tab Before the current tab. But, it turns out, that giant plus sign on the tab bar does add a new tab after the last tab. Go figure.
It’s amazing what you learn if you don’t try to make it complicated by searching help files and such. Just look at the screen!
This is not a valid answer to the original question “Can you set a default for new sheet location”{?}
The answer to the original question should be:
“No - except you call user code for the task.”
How such code would look and how it can be made available via the context menu of the Sheet TabsBar is demonstrated here (34.7 KB).
I will now edit the subject line of the question so that it better fits with your answer.
1 Like