View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default Macro for forward and back button

Hi,

Could someone please help me. This probably need macro.

I create 2 button in a sheet - one for forward and one for back. Their
function is to more to the next sheet or move to the previous sheet.

I tried to use hyperlink. The only problem is I have to set hyperlink on
every sheet. Is there a way or macro that I can assign to the button to tell
it to more to next or previous.

Thanks.
Kim