Linking macro's to UserForm

[Daniellawson]

I have created a macro in my Excel spreadsheet which is a button and when clicked uses the 'AutoFilter' function and selects a range of Grades in my spreadsheet,
(Grade = A,B,C,D)..

I have a UserForm for this database and was wandering how i can make the macro work when a button is clicked on the UserForm..

Thnx

 

[JohnG]

Try this

Under the button click event on the form type the name of the procedure the button on the sheet calls ( i suspect it lives in the 'ThisWorkbook' folder.

Hope this helps

 

[Daniellawson]

Im not too sure which button you mean? the one on my spreadsheet or UserForm??

Then on my userform i assign the macro to the buton??

 

[Daniellawson]

Also can a password be assigned so that when the Userform is opened a password has to be entered??