Minggu, April 26, 2015

Hide Excel Sheet/Worksheet With Usual Way OR Use Macro

4/26/2015 03:15:00 PM  "sahabat informasi"  No comments

To hide excel sheet which can be unhide with usual way:
  1. Usual way (do not use macro)
    Right click on sheet will be hide > Hide
  2. By using macro
    Developer Menu > Visual Basic > View > Project Explorer > View > Properties Window > Click on sheet which will be hide > On Properties Winodw, at Visible section choose "0 - xlSheetHidden"

To hide excel sheet which can not unhide with usual way, and only can unhide by using macro
Developer Menu > Visual Basic > View > Project Explorer > View > Properties Window > Click on sheet which will be hide > On Properties Winodw, at Visible section choose "2 - xlSheetVeryHidden"

Source: Tutorial Excel Indonesia: https://www.youtube.com/watch?v=CjeC1lqQuwI

Posted in:

0 komentar:

Posting Komentar