Buttons and macros
 

I have an excel file with about 20 sheets in it. To save time trying to
find the correct sheet needed I have a front sheet with macros to take
the user to the sheet they need to use. What I would like to know is
this? Can I put buttons on the page so that users can hit the relevant
button to run the relevant macro? If it is possible how do I do it?

I appreciate this is probably a basic thing but I am relatively
inexperienced.

Any help would be appreciated.




--
Richardisa1

Buttons and macros
 

"Richardisa1" wrote:

I have an excel file with about 20 sheets in it. To save time trying to
find the correct sheet needed I have a front sheet with macros to take
the user to the sheet they need to use. What I would like to know is
this? Can I put buttons on the page so that users can hit the relevant
button to run the relevant macro? If it is possible how do I do it?

Richard

You can use Form Buttons (Insert, Toolbars, forms) or draw a textbox from
the drawing tool icons. On the form buttons you will probably be prompted to
assign a macro. With the text boxes right-click and coose Assign Macro.

You could modify you macro to allow the user to select the sheet from a
single macro

Sub ChooseSheet()
sht = inputbox("Enter the sheet No")
worksheets(sh).select
end sub

Not checked

Peter

Buttons and macros
 

Brilliant. I guessed there was a solution. I've emailed it to my work
email box so I can use it on Monday. Thanks very much.




--
Richardisa1

Buttons and macros
 

"Richardisa1" wrote:

Brilliant. I guessed there was a solution. I've emailed it to my work
email box so I can use it on Monday. Thanks very much.


Richard

Thanks for the feedback

Peter