Error ending show from action button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've got a powerpoint pres (Kiosk style with action buttons for navigation)
that is launched as a help system from a dashboard.

I'm using an action button to exit and return to excel.

So far I've managed to avoid VBA, therefore avoiding all the warnings that
go along with it (the audience is about 400 people per month, so I don't want
them to have to click through loads of warnings).

My action button simply has a hyperlink to the end of the show.

Unfortunately, when it does this, powerpoint jumps in with a warning message:

Likewise, it then only closes the show, not powerpoint itself.

Can I get this to work properly without resorting to VBA?

Thanks in advance for any advice,

Cheers,

Tom.
 
Still need some help if anybody can...

mr tom said:
Hi,

I've got a powerpoint pres (Kiosk style with action buttons for navigation)
that is launched as a help system from a dashboard.

I'm using an action button to exit and return to excel.

So far I've managed to avoid VBA, therefore avoiding all the warnings that
go along with it (the audience is about 400 people per month, so I don't want
them to have to click through loads of warnings).

My action button simply has a hyperlink to the end of the show.

Unfortunately, when it does this, powerpoint jumps in with a warning message:


Likewise, it then only closes the show, not powerpoint itself.

Can I get this to work properly without resorting to VBA?

Thanks in advance for any advice,

Cheers,

Tom.
Click to expand...
 
documents you jumped to previously.

This doesn't sound like a PPT error message though.
Are you certain it's not coming from the dashboard system?

Also, have you given the presentation a .PPS extension or is it a .PPT?
 
Thanks, Steve.

The message is definately not from the dashboard system - it's excel based
(my own creation).

The ppt (it is a ppt) is launched via a hyperlink from Excel.

Interestingly, it does launch its own show - straight into Kiosk mode.
Wondering whether things work a bit differently when ppt is launched via
hyperlink. Especially as this error doesn't occur when the ppt is launched
by itself (i.e. without referencing it from excel - e.g. double clicking on
it in Explorer)
 
Thanks, Steve.

The message is definately not from the dashboard system - it's excel based
(my own creation).
Click to expand...

That's good; the fewer black boxes, the better.
The ppt (it is a ppt) is launched via a hyperlink from Excel.

Interestingly, it does launch its own show - straight into Kiosk mode.
Wondering whether things work a bit differently when ppt is launched via
hyperlink.
Click to expand...

Yes, very much so. And to make it more entertaining, the specifics change from one version to the next.
Especially as this error doesn't occur when the ppt is launched
by itself (i.e. without referencing it from excel - e.g. double clicking on
it in Explorer)
Click to expand...

That leads right into my next suggestion. Since you control the dashboard app, I'd try launching the show via
ShellExecute rather than hyperlinking.

Randy Birch has a nice bit of code that even lets you emulate a hyperlink:

http://vbnet.mvps.org/index.html?code/intrinsic/sehyperlink.htm

If it doesn't need to look like a hyperlink, you can use just the part of the code that invokes ShellExecute.
 
Thanks Steve, but if I use VBA, I'll be exchanging one warning message for
another - this one on launch of the dashboard.

I think I'll live with the current setup.

Thanks so much for trying to help.

Tom.
 
Thanks Steve, but if I use VBA, I'll be exchanging one warning message for
another - this one on launch of the dashboard.
Click to expand...

Oh ... I had the impression (wrong again, steve) that the dashboard was an app in Excel.
Ah well.
 
Yes - it is in Excel.

In Excel, if you open a spreadsheet containing VBA code, you receive a
warning message and are asked whether you want to proceed.

I guess it's getting users to answer that question every time they open the
dashboard in order to avoid them having to answer a question on the odd
occasion that they launch the help from within the dashboard.

Cheers,

Tom.
 
Getting myself in deeper with every attempt to climb outa the hole here but one more try ...

Yes - it is in Excel.
Click to expand...

And the part I left out was that I misunderstood it to be done in Excel with VBA.
Sorry for the confusion.
 
Back
Top