View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Ron de Bruin
 
Posts: n/a
Default Creating Buttons to navigate and drop down menus

You can add a button from the forms toolbar and assign a macro like this

ActiveSheet.Previous.Select

ActiveSheet.Next.Select



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ryan_dude" wrote in message ...
No i mean i need actual buttons, like a website on the excel page to navigate
throughout the workbook.
Any Ideas?

Thanks

"Ron de Bruin" wrote:

Hi Ryan

Maybe ?

Ctrl Page Up and Ctrl Page Down

Also i need to create a drop down menu, again a form tool??

right click on the arrows on the left of your first tab

--
Regards Ron de Bruin
http://www.rondebruin.nl


"ryan_dude" wrote in message ...
Hi
I need to create buttons so i can navigate from one sheet to the other
inside a workbook, is there some kind of form tool to do this with?

Also i need to create a drop down menu, again a form tool??

Many Thanks in advanced,
Ryan