CARA MENYEMBUNYIKAN MENU DEFAULT RIBBON EXCEL 2007, 2010 DAN 2013
Cara Mengatur Format Mata Uang Rupiah di Excel – Seperti yang kita ketahui Microsoft Excel merupakan aplikasi yang sangat powerfull dalam urusan membuat laporan keuangan dan berbagai macam pekerjaan kantor lainnya. Dengan aplikasi ini kita tidak perlu menggunakan kalkukator tambahan untuk menghitung laporan keuangan yang sedang kita buat.
Membuat menu tab ribbon sendiri di excel memang idaman bagi programer pemula seperti saya ini hehehe.. karena membuat tab menu ribbon sendiri di excel sebagai menu utama adalah pilihan yang pas untuk sebuah aplikasi sederhana.
Sebenarnya dalam pembuatan menu tab ribbon excel 2007 keatas tidaklah sesulit yang Anda bayangkan, Karena kita hanya membutuhkan beberapa kode xml UI Editor yang dapat Anda lihat diartikel kami sebelumnya Cara Membuat Menu Tab Ribbon Sendiri Di Excel 2007,2008 dan 2013 keatas.
Setelah Anda membaca postingan kami sebelumnya pastilah Anda sudah faham Cara Membuat Menu Tab Ribbon Di Excel 2007 keatas.
Seperti halnya gambar diatas, Kami membuatnya tidak lebih dari 2 menit, begitu mudah cara membuatnya, dan pasti Anda juga bisa membuatnya.
Tetapi permasalahannya adalah : Saya masih newbey mas ?
Untuk itu tidak ada salahnya jika Anda mengikuti kami terus di group fb atau di google plus atau suscribe channel youtube kami untuk mendapatkan berita terupdate seputar dunia microsoft excel dan dunia pendidikan.
Karena kami akan berusaha menerangkan secara detail dan mudah difahami meskipun para tamu kami yang masih newbey. oke sekarang silahkan ikuti langkah dibawah ini.
CARA MENYEMBUNYIKAN MENU DEFAULT RIBBON EXCEL 2007 KEATAS.
Perlu Anda ketahui bahwa, Microsoft Excel 2007 kebawah tidak bisa menampilkan menu tab ribbon excel buatan sendiri lhoo..
Setidaknya ada 2 alasan Mengapa Menu Ribbon Buatan Sendiri Tidak Muncul di excel 2007 kebawah : 1. Pada Software Custom UI Editor tidak terdapat layanan office 2007 kebawah 2. Sudah tidak jamannya (tidak support dengan MSDN dan atau penggunannya sangat sedikit) Nah.. sekarang Anda sedikit sudang mengerti Mengapa Menu Ribbon Buatan Sendiri Tidak Muncul Di Bawah Excel 2007. Oke kita kembali ke topik.. Berikut Langkah-Langkah Menyembunyikan Menu Default Ribbon Excel
1. Langkah pertama adalah Anda harus mempunyai Software UI Editor, jika Anda belum mempunyai softwarenya silahkan Download Software UI Editor dan cara menginstalnya Anda dapat mengunjungi postingan kami sebelumnya di 'Cara Menginstal Software UI Editor'.
3. Sehingga seperti gambar dibawah ini, dan pilih file excel yang ingin anda sembunyikan menu tab ribbon dengan cara klik icon warna kuning (disini saya pilih file akuntansi) lalu klik kanan pilih excel 2007 dan 2010. 4. Setelah itu silahkan salin kode xml ini dan tempelkan di UI Editor office 2010
5. Selanjutnya klik tombol validate (icon centang warna merah) 6. Jika kode xml nya sudah benar maka akan ada informasi vb information dan apabila kode xml nya masih salah maka akan ada vb critical. 7. Jika sudah ada informasi 'Custom UI XML is well formed' maka silahkan klik ok dan simpan lalu keluar. 8. Selanjutnya buka file excel Anda tadi dan lihat apakah sudah sama dengan gambar dibawah ini 9. Jika sudah seperti gambar diatas maka silahkan klik simpan dan selesai Selamat Anda sekarang sudah bisa membuat menu tab ribbon sendiri di excel 2007 keatas, dan serta menyembunyikan menu tab defaul ribbon excel.
Mas.. setelah saya coba dan pratikkan, di menu ribbon , gambarnya kok nggak seperti punyanya mas yaa ?? kenapa mas itu ??
Perlu diketahui bahwa, gambar/icon pada menu ribbon diatas adalah icon buatan kami sendiri. sehingga jika Kode XML nya Anda copy paste maka akan berhasil namun icon/gambarnya tidak muncul pada komputer/laptop Anda. Nah untuk memahami ini, berarti Anda perlu belajar 'Cara Membuat Icon Sendiri Di Ribbon Excel' yang dapat Anda pelajari di artikel kami 'CARA MEMBUAT ICON TRANSPARAN DI RIBBON EXCEL'
Terus untuk memngembalikan menu default ribbon excel bagaimana mas.. ?
Perhatikan dalam kode xml diatas ada kode seperti ini
Nah pada tulisan warna merah itu silahkan ganti false atau true <command idMso='ApplicationOptionsDialog' enabled='false'/> diganti true <ribbon startFromScratch='true'> diganti false
HARUS HURUF KECIL SEMUA dan itu berlaku di office 2007 dan office 2010
JIKA MENURUT ANDA ARTIKEL INI MUDAH DIFAHAMI DAN BERMANFAAT, SILAHKAN SHARE KE SOSIAL MEDIA YANG LAIN DENGAN TUJUAN BERBAGI ILMU DAN PENGETAHUAN KARENA BERBAGI ITU INDAH.
'Kami Selalu Berusaha Memberikan Yang Terbaik d,an Original Untuk Anda'
How to follow hyperlink to hidden sheet in Excel?
For example, I have a workbook which contains multiple worksheets, the first master sheet has hyperlinks to other sheets, and now, I hide all sheets except the first one. In this case, the hyperlinks which link to hidden sheets are not available. But, how could you make these hyperlinks work successfully? When you click one hyperlink, the linked hidden sheet will be opened at once as following screenshot shown:
Follow hyperlink to open hidden sheet with VBA code
Follow hyperlink to open hidden sheet and then hide it again with VBA code
With Kutools for Excel's Create List of Sheet Names utility, you can quickly list all worksheet names in a new sheet with hyperlinks or macro buttons as you need.
worksheet names with hyperlinks
worksheet names with macro buttons
Follow hyperlink to open hidden sheet with VBA code
The following VBA code may help you to open the hidden worksheet when clicking its relative hyperlink, please do as this:
1. Right click the sheet tab that you want to follow the hyperlink to hidden sheet, and then choose View Code from the context menu, in the popped out Microsoft Visual Basic for Applications window, please copy and paste the following code into the blank Module:
VBA code: Follow hyperlink to open hidden sheet:
Note: In the above code, the number 1 in this If Target.Column = 1 Then script indicates the column number which contains the hyperlinks, please change it your need.
2. Then save and close this code window, now, when you click the hyperlink which link to the specific hidden sheet, the hidden sheet will be opened at once.
Follow hyperlink to open hidden sheet and then hide it again with VBA code
Sometimes, you need to follow the hyperlink to open the hidden sheet, and when you go back the master sheet, you want the opened sheet to be hidden again. The below VBA code can do you a favor:
1. Right click the sheet tab that you want to follow the hyperlink to hidden sheet, and then choose View Code from the context menu, in the popped out Microsoft Visual Basic for Applications window, please copy and paste the following code into the blank Module:
VBA code: Follow hyperlink to open hidden sheet when go back hide it again:
2. Then save ad clos the code window, when you click the hyperlink, the linked hidden sheet will be opened immediately, but, if you go back the master sheet which contains the hyperlinks, the opened sheet will be hidden automatically again.
Note: Theses codes are only applied to the sheet names which match your hyperlink text.
Demo: Follow hyperlink to open hidden sheet with VBA code
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than300 powerful features. Supports Office/Excel2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
I would like to use this code but only want it to apply to column A. I have other web address links in other cells which cause a problem when running this code.
To post as a guest, your comment is unpublished.
My hyperlink 'text' is number only, and it doesn't work...
To post as a guest, your comment is unpublished.
I'm using the code on two different sheets. It works for one of about 40 hyperlinks on one sheet and it opens two of about 10 hyperlinks one she second, the sheets on the second which do open do go back into hiding when I return to the sheet. The error I get when it will not open a sheet is Run-time error'9': script out of range and the code it points me to - Sheets(strLinkSheet).Visible = True Any ideas as to what change is needed make the code work on all of the sheets? Thank you in advance.
To post as a guest, your comment is unpublished.
I have used this code on two different sheets in my workbook, and in both cases it works great, except for the first hyperlink on each page. I get 'Subscript out of range error' and the debugger points to the 'Sheets(strLinkSheet).Visible = True' right after the 'end if'. Anyone else see this error? It is only on the first link on the page. (my hyperlinks are in column A, and start in row 2)
[quote name='HelzBelz']I have used this code on two different sheets in my workbook, and in both cases it works great, except for the first hyperlink on each page. I get 'Subscript out of range error' and the debugger points to the 'Sheets(strLinkSheet).Visible = True' right after the 'end if'. Anyone else see this error? It is only on the first link on the page. (my hyperlinks are in column A, and start in row 2)[/quote] Sheet names can't have space like 'Sheet 1'. I fixed my sheet names to 'Sheet1' and the error stopped.
To post as a guest, your comment is unpublished.
I have a sheet that is hidden that contains a hyperlink. I would like to be able go to the hidden sheet and have it close when I go back to the original sheet. I used the code but it does not work.
To post as a guest, your comment is unpublished.
I am trying to hide a sheet that has a hyperlink. I would like to be able to click on the sheet go to the hyperlink sheet and then click back to the sheet and close the hidden sheet. I have tried your instructions but it does not work. Not sure what I am doing wrong.