Hello,
I have a 2003 spreadsheet with multiple pages and am trying to create navigation buttons (back and next) to move between the sheets.
I'm trying to think of a way to have an image used as a button with over/up/down states and run a macro on click.
The nearest I can get is using a control toolbox image object and then using the mouseMove function but then that would need to determine whether the mouse was moving over or out of the object.
Even if this is sucessful though it will need duplicating across every sheet so maybe that can also be automated by coping the whole thing from a 'template' sheet.
Anybody any ideas?
I have a 2003 spreadsheet with multiple pages and am trying to create navigation buttons (back and next) to move between the sheets.
I'm trying to think of a way to have an image used as a button with over/up/down states and run a macro on click.
The nearest I can get is using a control toolbox image object and then using the mouseMove function but then that would need to determine whether the mouse was moving over or out of the object.
Even if this is sucessful though it will need duplicating across every sheet so maybe that can also be automated by coping the whole thing from a 'template' sheet.
Anybody any ideas?
