Calling a macro from a menu item but then needs to run a case modu

  • Thread starter James Price at Premier
  • Start date
J

James Price at Premier

I have created a form that allows the user to link shapes to a new page. In
order to do this I have turned eventsenabling off and then back on at the
end.

I've then created a macro that shows the form. When the form has run its
code, the macro continues by then kicking off a case module (the case module
updates the linked page when the user clicks on that page). [When I run the
form the links to the case module seem to get 'lost' hence the need to get
another 'connection']

For the macro to run the case module I have put it into thisdocuments (as I
can't get it to run from a module sheet). However the rub is this if I want
to run the macro from a drop down menu, the AddOnName doesn't see the macro
in the thisdocument only in a module sheet.

Help!...

Many thanks

James
 
J

James Price at Premier

Sorry everyone - I was being a bozo (it was a long week!)

Cheers

James
 
D

David J Parker [MVP Visio]

James ... are your weeks actually any longer than the rest of us?
If so, which web site did you buy them from?
:)


James Price at Premier said:
Sorry everyone - I was being a bozo (it was a long week!)

Cheers

James


James Price at Premier said:
I have created a form that allows the user to link shapes to a new page.
In
order to do this I have turned eventsenabling off and then back on at the
end.

I've then created a macro that shows the form. When the form has run its
code, the macro continues by then kicking off a case module (the case
module
updates the linked page when the user clicks on that page). [When I run
the
form the links to the case module seem to get 'lost' hence the need to
get
another 'connection']

For the macro to run the case module I have put it into thisdocuments (as
I
can't get it to run from a module sheet). However the rub is this if I
want
to run the macro from a drop down menu, the AddOnName doesn't see the
macro
in the thisdocument only in a module sheet.

Help!...

Many thanks

James
 
A

AlEdlund

David,
Nice to have you back, it's been quiet without you..
al


David J Parker said:
James ... are your weeks actually any longer than the rest of us?
If so, which web site did you buy them from?
:)


"James Price at Premier" <[email protected]>
wrote in message
Sorry everyone - I was being a bozo (it was a long week!)

Cheers

James


James Price at Premier said:
I have created a form that allows the user to link shapes to a new page.
In
order to do this I have turned eventsenabling off and then back on at
the
end.

I've then created a macro that shows the form. When the form has run
its
code, the macro continues by then kicking off a case module (the case
module
updates the linked page when the user clicks on that page). [When I run
the
form the links to the case module seem to get 'lost' hence the need to
get
another 'connection']

For the macro to run the case module I have put it into thisdocuments
(as I
can't get it to run from a module sheet). However the rub is this if I
want
to run the macro from a drop down menu, the AddOnName doesn't see the
macro
in the thisdocument only in a module sheet.

Help!...

Many thanks

James
 
D

David J Parker [MVP Visio]

Sorry Al ... if you read my blog you'll know why I've been absent from
here....

AlEdlund said:
David,
Nice to have you back, it's been quiet without you..
al


David J Parker said:
James ... are your weeks actually any longer than the rest of us?
If so, which web site did you buy them from?
:)


"James Price at Premier" <[email protected]>
wrote in message
Sorry everyone - I was being a bozo (it was a long week!)

Cheers

James


:

I have created a form that allows the user to link shapes to a new
page. In
order to do this I have turned eventsenabling off and then back on at
the
end.

I've then created a macro that shows the form. When the form has run
its
code, the macro continues by then kicking off a case module (the case
module
updates the linked page when the user clicks on that page). [When I
run the
form the links to the case module seem to get 'lost' hence the need to
get
another 'connection']

For the macro to run the case module I have put it into thisdocuments
(as I
can't get it to run from a module sheet). However the rub is this if I
want
to run the macro from a drop down menu, the AddOnName doesn't see the
macro
in the thisdocument only in a module sheet.

Help!...

Many thanks

James
 
A

AlEdlund

saw it! as usual an amazing piece of work.
al


David J Parker said:
Sorry Al ... if you read my blog you'll know why I've been absent from
here....

AlEdlund said:
David,
Nice to have you back, it's been quiet without you..
al


David J Parker said:
James ... are your weeks actually any longer than the rest of us?
If so, which web site did you buy them from?
:)


"James Price at Premier" <[email protected]>
wrote in message

Sorry everyone - I was being a bozo (it was a long week!)

Cheers

James


:

I have created a form that allows the user to link shapes to a new
page. In
order to do this I have turned eventsenabling off and then back on at
the
end.

I've then created a macro that shows the form. When the form has run
its
code, the macro continues by then kicking off a case module (the case
module
updates the linked page when the user clicks on that page). [When I
run the
form the links to the case module seem to get 'lost' hence the need to
get
another 'connection']

For the macro to run the case module I have put it into thisdocuments
(as I
can't get it to run from a module sheet). However the rub is this if
I want
to run the macro from a drop down menu, the AddOnName doesn't see the
macro
in the thisdocument only in a module sheet.

Help!...

Many thanks

James
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top