Is this possible.
I Have two workbooks.
Master.xls and Slave.xls
Is it possible to call a form called MainMenu in Master.xls from a button on
a sheet in Slave.xls
--
Regards and Thanks for any assistance.
Francis Brown.
Is this possible.
I Have two workbooks.
Master.xls and Slave.xls
Is it possible to call a form called MainMenu in Master.xls from a button on
a sheet in Slave.xls
--
Regards and Thanks for any assistance.
Francis Brown.
You could have a subroutine in master.xls that shows the form:
Option explicit
sub ShowTheForm()
mainmenu.show
end sub
Then you could have a macro assigned to that commandbutton (from the control
toolbox toolbar) that does the actual call.
option explicit
Private Sub CommandButton1_Click()
application.run "master.xls!showtheform"
end sub
You could also assign this kind of macro to a button from the Forms toolbar.
Or with the forms toolbar, you could just assign the macro in the master.xls
workbook directly (rightclick and assign macro).
======
If you use the application.run stuff, then master.xls will have to be open. If
you assign the macro to the forms button, then excel will open master.xls (if
it's not already open).
Francis Brown wrote:
>
> Is this possible.
>
> I Have two workbooks.
>
> Master.xls and Slave.xls
>
> Is it possible to call a form called MainMenu in Master.xls from a button on
> a sheet in Slave.xls
>
> --
> Regards and Thanks for any assistance.
>
> Francis Brown.
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks