Re: [belajar-excel] File excel dengan macro di dalam file tsb

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Hai Tio,
Tidak harus.File Excel berisi Macro dengan Extension .xls bisa dijalankan di 
Excel 2003, 2007, 2010 dan 2013..sedangkan file yang berextension .xlsx (Excel 
Workbook versi 2007 ke atas) tidak bisa menyimpan macro...apalagi 
menjalankannya --> jadi berhati2lah pada saat menyimpan file berisi macro (akan 
ada peringatan).
Salam,HK
      From: "Tio Adi Bayu Adjie tio.ad...@ptssb.co.id [belajar-excel]" 
<belajar-excel@yahoogroups.com>
 To: belajar-excel@yahoogroups.com 
 Sent: Thursday, 28 May 2015, 13:35
 Subject: [belajar-excel] File excel dengan macro di dalam file tsb
   
    Salam BeExcel, Mau Tanya, apakah file yang ada macro harus diganti filenya 
dengan extensi xlsm ? dan berarti kalau xls tidak jalan macronya ? Ternyata 
saya coba buat file dengan extensi xls berhasil macronya. Ini macronya : Sub 
Button1_Click() Cells(2, 4).Select Range(Cells(2, 4), Cells(2, 
4).End(xlDown)).Name = "rngTanggal" End Sub    Mohon pencerahannya, kenapa file 
extensi xls bisa jalan dengan macro tsb. ?    Terima kasih.            
#yiv2846914235 -- #yiv2846914235ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2846914235 
#yiv2846914235ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2846914235 
#yiv2846914235ygrp-mkp #yiv2846914235hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2846914235 #yiv2846914235ygrp-mkp #yiv2846914235ads 
{margin-bottom:10px;}#yiv2846914235 #yiv2846914235ygrp-mkp .yiv2846914235ad 
{padding:0 0;}#yiv2846914235 #yiv2846914235ygrp-mkp .yiv2846914235ad p 
{margin:0;}#yiv2846914235 #yiv2846914235ygrp-mkp .yiv2846914235ad a 
{color:#0000ff;text-decoration:none;}#yiv2846914235 #yiv2846914235ygrp-sponsor 
#yiv2846914235ygrp-lc {font-family:Arial;}#yiv2846914235 
#yiv2846914235ygrp-sponsor #yiv2846914235ygrp-lc #yiv2846914235hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2846914235 
#yiv2846914235ygrp-sponsor #yiv2846914235ygrp-lc .yiv2846914235ad 
{margin-bottom:10px;padding:0 0;}#yiv2846914235 #yiv2846914235actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2846914235 
#yiv2846914235activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2846914235
 #yiv2846914235activity span {font-weight:700;}#yiv2846914235 
#yiv2846914235activity span:first-child 
{text-transform:uppercase;}#yiv2846914235 #yiv2846914235activity span a 
{color:#5085b6;text-decoration:none;}#yiv2846914235 #yiv2846914235activity span 
span {color:#ff7900;}#yiv2846914235 #yiv2846914235activity span 
.yiv2846914235underline {text-decoration:underline;}#yiv2846914235 
.yiv2846914235attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2846914235 .yiv2846914235attach div a 
{text-decoration:none;}#yiv2846914235 .yiv2846914235attach img 
{border:none;padding-right:5px;}#yiv2846914235 .yiv2846914235attach label 
{display:block;margin-bottom:5px;}#yiv2846914235 .yiv2846914235attach label a 
{text-decoration:none;}#yiv2846914235 blockquote {margin:0 0 0 
4px;}#yiv2846914235 .yiv2846914235bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2846914235 
.yiv2846914235bold a {text-decoration:none;}#yiv2846914235 dd.yiv2846914235last 
p a {font-family:Verdana;font-weight:700;}#yiv2846914235 dd.yiv2846914235last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2846914235 
dd.yiv2846914235last p span.yiv2846914235yshortcuts 
{margin-right:0;}#yiv2846914235 div.yiv2846914235attach-table div div a 
{text-decoration:none;}#yiv2846914235 div.yiv2846914235attach-table 
{width:400px;}#yiv2846914235 div.yiv2846914235file-title a, #yiv2846914235 
div.yiv2846914235file-title a:active, #yiv2846914235 
div.yiv2846914235file-title a:hover, #yiv2846914235 div.yiv2846914235file-title 
a:visited {text-decoration:none;}#yiv2846914235 div.yiv2846914235photo-title a, 
#yiv2846914235 div.yiv2846914235photo-title a:active, #yiv2846914235 
div.yiv2846914235photo-title a:hover, #yiv2846914235 
div.yiv2846914235photo-title a:visited {text-decoration:none;}#yiv2846914235 
div#yiv2846914235ygrp-mlmsg #yiv2846914235ygrp-msg p a 
span.yiv2846914235yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2846914235 
.yiv2846914235green {color:#628c2a;}#yiv2846914235 .yiv2846914235MsoNormal 
{margin:0 0 0 0;}#yiv2846914235 o {font-size:0;}#yiv2846914235 
#yiv2846914235photos div {float:left;width:72px;}#yiv2846914235 
#yiv2846914235photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv2846914235 
#yiv2846914235photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2846914235
  #yiv2846914235reco-category {font-size:77%;}#yiv2846914235 
#yiv2846914235reco-desc {font-size:77%;}#yiv2846914235 .yiv2846914235replbq 
{margin:4px;}#yiv2846914235 #yiv2846914235ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2846914235 #yiv2846914235ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2846914235 
#yiv2846914235ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2846914235 
#yiv2846914235ygrp-mlmsg select, #yiv2846914235 input, #yiv2846914235 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2846914235 
#yiv2846914235ygrp-mlmsg pre, #yiv2846914235 code {font:115% 
monospace;}#yiv2846914235 #yiv2846914235ygrp-mlmsg * 
{line-height:1.22em;}#yiv2846914235 #yiv2846914235ygrp-mlmsg #yiv2846914235logo 
{padding-bottom:10px;}#yiv2846914235 #yiv2846914235ygrp-msg p a 
{font-family:Verdana;}#yiv2846914235 #yiv2846914235ygrp-msg 
p#yiv2846914235attach-count span {color:#1E66AE;font-weight:700;}#yiv2846914235 
#yiv2846914235ygrp-reco #yiv2846914235reco-head 
{color:#ff7900;font-weight:700;}#yiv2846914235 #yiv2846914235ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv2846914235 #yiv2846914235ygrp-sponsor 
#yiv2846914235ov li a {font-size:130%;text-decoration:none;}#yiv2846914235 
#yiv2846914235ygrp-sponsor #yiv2846914235ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2846914235 
#yiv2846914235ygrp-sponsor #yiv2846914235ov ul {margin:0;padding:0 0 0 
8px;}#yiv2846914235 #yiv2846914235ygrp-text 
{font-family:Georgia;}#yiv2846914235 #yiv2846914235ygrp-text p {margin:0 0 1em 
0;}#yiv2846914235 #yiv2846914235ygrp-text tt {font-size:120%;}#yiv2846914235 
#yiv2846914235ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv2846914235