MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 323|Reply: 6

Update Multiple Linked Slideshows

[Copy link]

1

Topics

1

Posts

5

Integral

Newbie

Rank: 1

Integral
5
Post on 9-14-2016 18:30:13 | All posts |Read mode
Hi All,
I have a number of presentations that link to the same workbook in Excel.
For simplicity, let's assume there are only two, Show A  Show B.
The links are predominantly graphs, the slideshows run at the same time on loop and all graphs are set to auto update.
I have the below code in each presentation, kindly supplied by Jaslake:-
Sub OnSlideShowPageChange()
    Dim i As Integer
    i = ActivePresentation.SlideShowWindow.View.CurrentShowPosition
    If i  1 Then Exit Sub
           ActivePresentation.UpdateLinks
   
End SubThe issue I have is that only the presentation that has focus upates. i.e. if Show A is selected, Show B will not update.
The salient part of the code is ActivePresentation.Updatelinks. Is there a command that will say AllPresentation.Updatelinks or, can I pass focus onto the next presentation and perform the update?
This is driving me nuts!
Thanks for any help you can give, Feastie.
Reply

Props Report

9

Topics

463

Posts

1059

Integral

King

Rank: 6Rank: 6

Integral
1059
Post on 11-2-2016 12:12:52 | All posts



Is this in a Userform or a cell?











Reply Support Opposition

Props Report

2

Topics

103

Posts

220

Integral

Conqueror

Rank: 3Rank: 3

Integral
220
Post on 11-2-2016 13:25:58 | All posts



cell, want to try this in empty worksheet and then use in my table




Reply Support Opposition

Props Report

39

Topics

2573

Posts

5415

Integral

Forum Legend

Rank: 8Rank: 8

Integral
5415
Post on 11-2-2016 14:02:53 | All posts



How will excel know which month you want? Is it the current month and year?
How many cells are involved?
You could get auto finish to kick in, but it would require a macro attached to the cell so that when you type the day, the month and year will appear.
Regards,
David




Reply Support Opposition

Props Report

2

Topics

103

Posts

220

Integral

Conqueror

Rank: 3Rank: 3

Integral
220
Post on 11-2-2016 14:37:19 | All posts



Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Thanks!











Reply Support Opposition

Props Report

39

Topics

2573

Posts

5415

Integral

Forum Legend

Rank: 8Rank: 8

Integral
5415
Post on 11-2-2016 16:00:34 | All posts



What I am trying to do is that make just friendly entry so something like that: cell dd/mm/yy was already in that form and you just type e.g. 14 01 15 and it would display 14/01/15 and I want that during typing was shown slashes want to know if that is possible and if so , how?




Reply Support Opposition

Props Report

2

Topics

103

Posts

220

Integral

Conqueror

Rank: 3Rank: 3

Integral
220
Post on 11-2-2016 16:09:43 | All posts



@Stolba - you have been asked to amend your thread title. This is not optional.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-25-2017 11:42 , Processed in 0.357115 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!