Buttons and macros

  • Thread starter Thread starter Richardisa1
  • Start date Start date
R

Richardisa1

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 said:
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?
Click to expand...

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
 
Brilliant. I guessed there was a solution. I've emailed it to my wor
email box so I can use it on Monday. Thanks very much
 
Richardisa1 said:
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.
Click to expand...
Richard

Thanks for the feedback

Peter
 
Back
Top