Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
can anyone suggest me by clicking button(next) in one sheet it should take me to the next sheet how to do this.
Hi,
Got to properties of button > Actions > Add Action > layout and choose Activate Sheet.
You need to give Sheet ID in Activate sheet. You will get the sheet ID in Sheet properties.
Thanks
Advait
Hi,
I would put a button object on the sheet. When creating the button go to 'Actions' tab and press 'Add', highlight 'Layout' and select 'Activate Next Sheet'. Then create another button that has 'Activate Previous Sheet'. Name it next and previous and voila!
-art
yesssss.......thankyou alot thakur ....i got it