Good morning all,
I'm after a little help (well, a lot of help actually)! I've created a menu using VBA and I have this nifty little back button. I can make it work for the last sheet viewed, but not for more than one sheet.
For example: If I am on sheet1, run a macro to go to sheet2, I can use my back button to return to sheet1. However, if I go from sheet1 to sheet2 and then sheet3 (all via macros), I cannot get back to sheet1 using my button.
Is there any way to create history somewhere and then move backwards along that history every time the back button is pressed?
I've thought about writing the active sheet to a hidden sheet somehow and then moving back up the list, but my VBA skills are not up to the task.
Any help would be much appreciated.
Asante sana!
I'm after a little help (well, a lot of help actually)! I've created a menu using VBA and I have this nifty little back button. I can make it work for the last sheet viewed, but not for more than one sheet.
For example: If I am on sheet1, run a macro to go to sheet2, I can use my back button to return to sheet1. However, if I go from sheet1 to sheet2 and then sheet3 (all via macros), I cannot get back to sheet1 using my button.
Is there any way to create history somewhere and then move backwards along that history every time the back button is pressed?
I've thought about writing the active sheet to a hidden sheet somehow and then moving back up the list, but my VBA skills are not up to the task.
Any help would be much appreciated.
Asante sana!