Workbook yg sudah di set sebagai 'Share Workbook' akan berkurang beberapa fitures nya, artinya dia mengalami keterbatasan-keterbatasan. Berikut ini adalah daftarnya
| Features that are not supported in a shared workbook | ||
|
|
| |
| IN A SHARED WORKBOOK, YOU CANNOT | BUT YOU MAY BE ABLE TO DO THE FOLLOWING | |
| Create an Excel table | None | |
| Insert or delete blocks of cells | You can insert entire rows and columns. | |
| Delete worksheets | None | |
| Merge cells or split merged cells | None | |
| Add or change conditional formats | Existing conditional formats continue to appear as cell values change, but you can't change these formats or redefine the conditions. | |
| Add or change data validation | Cells continue to be validated when you type new values, but you can't change existing data validation settings. | |
| Create or change charts or PivotChart reports | You can view existing charts and reports. | |
| Insert or change pictures or other objects | You can view existing pictures and objects. | |
| Insert or change hyperlinks | Existing hyperlinks continue to work. | |
| Use drawing tools | You can view existing drawings and graphics. | |
| Assign, change, or remove passwords | Existing passwords remain in effect. | |
| Protect or unprotect worksheets or the workbook | Existing protection remains in effect. | |
| Create, change, or view scenarios | None | |
| Group or outline data | You can continue to use existing outlines. | |
| Insert automatic subtotals | You can view existing subtotals. | |
| Create data tables | You can view existing data tables. | |
| Create or change PivotTable reports | You can view existing reports. | |
| Write, record, change, view, or assign macros | You can run existing macros that don't access unavailable features. You can record shared workbook operations into a macro stored in another nonshared workbook. | |
| Add or change Microsoft Excel 4 dialog sheets | None | |
| Change or delete array formulas | Existing array formulas continue to calculate correctly. | |
| Use a data form to add new data | You can use a data form to find a record. | |
| Work with XML data, including: | None | |
| Import, refresh, and export XML data | ||
| Add, rename, or delete XML maps | ||
| Map cells to XML elements | ||
| Use the XML Source task pane, XML toolbar, or XML commands on the Data menu | ||
Mas Muhib,
Apa yg Mas sebutkan sudah saya lakukan..dan itu memang setting untuk aktifkan macros,..
Macros berjalan dengan baik dan ini program memang sudah jadi dari "Pakar" nya juga...Hanya saja program ini mau saya share ke SERVER agar bisa digunakan oleh seluruh karyawan.
Ketika setting "Share workbook" pada "review" menu di aktifkan, maka muncullah message yang disebut pada posting sebelumnya,...
Mohon bantuannya lagi..
thanks..
gilang
--- In XL-mania@yahoogroups.com, moheb boellah <brohebnol@...> wrote:
> mas Gilang,
> di PC dimana data anda dishare, Macro sepertinya belum di_set Enable. Caranya spt berikut:
> Buka MS Excel
> Buka Excel Option,
> Setelah muncul dialog box Excel Option, klik Trust Center, pilih Trust Center Settings..
> Kemudian di dialog box Trust Center, klik Macro Settings, pilih Enable All Macros & thick mark
> Trust access to the VBA project object model.> Dari: Gilang Patriot <gilangpatriot@...>
> Tinggal klik Ok & Ok lagi...
> Buka file yang menggunakan Macro.. semoga macro sudah bisa dijalankan.
>
> Oya, meski di PC yang sama, jika User Account_nya beda, juga mesti diset enable terlebih dahulu.
>
> Regards,
> Muhib
> ________________________________> Dikirim: Senin, 28 Mei 2012 12:27
> "Bagaimana caranya agar Macros tetap bisa dibaca maupun edit jika file di sharing.> Setelah file dishare di Review---Share workbookâ€"> Muncul informasi :
> "This workbook contains macros recorded or written in visual basic. Macros
> cannot viewed or edited in shared workbooks"
>
> Walau saya OK kan, tapi macro tetap tidak bekerja, muncul message "Run-time
> error `1004': Unprotect method of worksheet class failed"
> Mohon infonya bagaimana cara mensetting agar macro tetap jalan saat workbook di-sharing.
>
> Mohon maaf jika topik ini sudah dibahas,
> terimakasih atas bantuannya
>
> salam
> gilang
| Delay pada posting disebabkan sibuknya momods dan leletnya |
| koneksi dengan ind***t. bwakakakaka....
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
