To use any scripts written under this publication…

VBA allows you to perform some sophisticated / routine work without manual operation. Further, construct user form is one of powerful tools for you too. You can design a customized interface to guide your users while using your spreadsheets. The following are some shortcuts/ syntax I frequently used when design macros. I guess these might help for some ppl.


To use any scripts written under this publication…

1. Open any existing Excel workbook
2. Press Alt+F11 — This will open the VBA Editor
3. Insert a code module from then insert menu
4. Copy the above code and paste in the code module which have inserted in the above step
5. Activate any workbook
6. Now press F5 to execute the VBA Cheat Sheets

Tips

Hide the sheets and forbidden the unhide function

1. Go to the VS editor
2. Choose the sheet you want to hide under "Project - VBAProject"
3. Go to the "Properties" and turn Visible into "2 - xlSheetVeryHidden"