[belajar-excel] Share as ReadOnly

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Share as ReadOnly

Heru Safrudin
Dear Master,

Saya punya file master yang saya gunakan sebagai interface, saya ingin
copy file master tersebut ke share folder dengan attribut Readonly
dengan sekali klik.
Bagaimana penulisan code/macronya ?

--
Terima kasih

وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Heru Safrudin


------------------------------------

---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
[hidden email]

posting ke milis, kirimkan ke:
[hidden email]

berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran
http://www.mail-archive.com/belajar-excel@.../
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: [hidden email]

keluar dari membership milis (UnSubscribe):
kirim mail kosong ke  [hidden email]
---------------------------------------------------------------------Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/belajar-excel/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/belajar-excel/join
    (Yahoo! ID required)

<*> To change settings via email:
    [hidden email]
    [hidden email]

<*> To unsubscribe from this group, send an email to:
    [hidden email]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Share as ReadOnly

Kid
Administrator
Assalamu'alaikum Wr. Wb.

Coba script berikut disesuaikan dengan keadaan real di lapangan dan
dikembangkan pemanfaatannya.

dim sFile as string

application.displayalerts=false
with thisworkbook
    .save
    sfile= .path & "\namafilesalinan.xls"
    .savecopyas sfile
    setattr sfile,vbreadonly
end with
application.displayalerts=true

Wassalamu'alaikum Wr. Wb.
Kid.

2013/3/5 Heru Safrudin <[hidden email]>

> Dear Master,
>
> Saya punya file master yang saya gunakan sebagai interface, saya ingin
> copy file master tersebut ke share folder dengan attribut Readonly
> dengan sekali klik.
> Bagaimana penulisan code/macronya ?
>
> --
> Terima kasih
>
> وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
> Heru Safrudin
>
>
> ------------------------------------
>
> ---------------------------------------------------------------------
> bergabung ke milis (subscribe), kirim mail kosong ke:
> [hidden email]
>
> posting ke milis, kirimkan ke:
> [hidden email]
>
> berkunjung ke web milis
> http://tech.groups.yahoo.com/group/belajar-excel/messages
>
> melihat file archive / mendownload lampiran
> http://www.mail-archive.com/belajar-excel@.../
> atau (sejak 25-Apr-2011) bisa juga di :
> http://milis-belajar-excel.1048464.n5.nabble.com/
>
> menghubungi moderators & owners: [hidden email]
>
> keluar dari membership milis (UnSubscribe):
> kirim mail kosong ke  [hidden email]
> ---------------------------------------------------------------------Yahoo!
> Groups Links
>
>
>
>