Kamis, 30 Juni 2016

[belajar-excel] Digest Number 3901

Milis Belajar Microsoft Excel Group 1 Message Digest #3901 1 (ask) Membuat unsur teks dalam formula menjadi huruf tebal by sondyargy Message 1 ...
READ MORE....

Rabu, 29 Juni 2016

[belajar-excel] Digest Number 3900

Milis Belajar Microsoft Excel Group 3 Messages Digest #3900 1a Re: Filter data diantara dua tanggal by "Warsito Ito" warsitoito14 2a Re: Mengambil 1 data dari salah satu 3 kolom secara prioritas ...
READ MORE....

Selasa, 28 Juni 2016

Re: [ExcelVBA] URL opens file but fails

  Hello,I am in the Trust Center"Trusted Publishers" has only one entry and it has nothing to do with Excel or Microsoft, but has VeriSign Class 3 Code ...""Trusted Locations" are all part of my "C:\ ...." drive, but do have Excel mentioned in all of them."Add-ins" nothing is checked (3 choices), but do not seem applicable?"ActiveX Settings" radio button "Prompt me before enabling ..." is checked AND "Safe mode (helps limit the control's ... ) is also checked."Macro Settings" radio button, Enable all macros ..." is checked and "Trust access to the VBA ... " is also checked.Message Bar - "Show the message bar ..." is checked."Enternal Content" Radio button "Enable all ata Connections... " is checked...
READ MORE....

Re: [ExcelVBA] URL opens file but fails

  I wonder if it is your file block settings in file/options/trust centre settings When you look at this remember if something is ticked under open, it means you cannot open it.  i.e. open is blocked.RegardsDavid Grugeon On 29 June 2016 at 10:17, David who1012000@yahoo.com [ExcelVBA] <ExcelVBA@yahoogroups.com> wrote: Yes. I think the only place it will not work is from the code and like I said before it use to work. I am guessing that a parameter with in the computer has changed, but I do not know where to locate this and change it back.Thanks for your time and efforts.David From: "'Tim Lewis' twlewis@reagan.com [ExcelVBA]" <ExcelVBA@yahoogroups.com>...
READ MORE....