8. Excel macro security

In Excel 2003 by default will display a security warning dialog box when the user opens the workbook in which there are macros. Above dialog box warning that the workbook that you have nuka macros. This warning is given to prevent dangerous dijalakanya macros. If you do not recognize the macros in the workbook, press the Disable Macros to disable macros. If you know the macros in the workbook and was intending to use it, press the Enable Macros to enable macros.

• To facilitate the creation of applications that I discuss at this time, the security warning dialog box to temporarily disable our first, perform the following steps:Select the menu Tools> Macro> Security ... Security dialog box appears as shown below.

• Select the Security Level tab. To be included in the workbook Macro always run without a Security Warning dialog box, select Low.
• Select the tab Trused Publishers. Tick ​​the option Trust installled all add-ins and templates and Trust access to Visual Basic Project. press the OK

7. Visual Basic Editor (VBE) in macro Excel 2003

Visual Basic Editor is a Visual Basic programming tools in Microsoft Office is used to create simple or complex applications.

1. To display the Visual Basic Editor in Excel 2003 menu select Tools > Macro > Visual Basic Editor.
2. View Visual Basic Editor

6. Optimizing Excel macro features

Macro, a popular term of visual basic for application (VBA), arguably the best features of hundreds of the best features excel excel others. The use of macros in excel feature has several advantages:

• Saves time: Peneyelesaian a job using the macros will be faster when compared to manually
• Saves energy: In addition to saving time, completion of the work using macros can also save on labor because the process takes place automatically.
• Reduce the error rate: Probability Danya error in completing a task manually can happen, even though you are a very proficient in using Excel. The program made ​​use macros consistently suatau akana complete the work by writing macros in the code so that the error rate that may arise are very small. Errors can only occur if there is an error if the macro commands in the code

All Tutorial and Article, Tutorial, Article

5. How change package format on linux backtrack 2 & 3

Additional file format type information on backtrack:

1. mo2lzm: This program is used to change the old slax package -->mo into slax module that is currently used is lzm.
2. tgz2lzm: This program is used to change the old slax package -->tgz into slax module that is currently used is lzm.
3. deb2lzm: This program is used to change the old yag slax package -->deb into slax module that is currently used is lzm.
4. dir2lzm: This program is used to change the old yag slax package -->dir is a module that is currently used slax lzm ie.

how to change it is

1. mo2lzm namafile.mo namafile.lzm
2. tgz2lzm namafile.tgz namafile.lzm
3. deb2lzm namafile.deb namafile.lzm
4. dir2lzm namafile.dir namafile.lzm

but if you have a format file like this

1. rpm2tgz: This program is used to change the old yag slax package -->rpm into slax module that is currently used the tgz
2. cpan2tgz: This program is used to change the old yag slax package -->cpan is a slax module that is currently used the tgz

All Tutorial and Article, Tutorial, Article

4. Setting conection oracle 6i to oracle database 10g

Most people are confused to find out how to connect oracle developer 6i to oracle database 10g by it because I tried a knowledge of how do you connect these two pemrogramanan oracle .... without further ado let's get straight to the scene .....
1. open notepad
2. syntac copy this:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))
)
(CONNECT_DATA8COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
NAMA_KONEKSI =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

(CONNECT_DATA = (SID = database_name))

)
3. save with the name of the tnsnames.ora
4. entered in the drive when you install oracle 6i, for example, on drive C:
5. locate the folder whose name orant
6. then open the folder, then open the folder NET80
7. there there is a folder named ADMIN
8. This saaatnya copy the tnsnames.ora file that you created earlier.
9. our mission complite dah ok, now oracle 6i and oracle database 10g is
connected



All Tutorial and Article, Tutorial, Article

3. Funy bypass game solitare in windows

want to smoke but do not have money, have embarrassed mending invite friends to play solitaire dexterity in XP
wrote press fitting careless friend
ALT + SHIFT +2
WOOOHOOO win ... I can be engrossed in cigarette
: wink:

All Tutorial and Article, Tutorial, Article

2. How to open file super hidden in your computer

sometimes we know that the virus and the hand of the wicked it is less enjoyable .... especially concerned with the important files that exist within our computer or laptop .... I'll show you how to overcome the virus or mischievous hands trying to create your important files hidden by permanene us ....

1. Open notepad

2. Type attrib-s [space]-h [space]-r [space] / s [space] / d

3. Keep the name hiden.bat in place in hidden files

4. Then double click the left mouse button the file ....

5. Binggo file is back as usual

All Tutorial and Article, Tutorial, Article

1. How to hidden drive in your computer

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer

"NoDrives"=dword:data


All Tutorial and Article, Tutorial, Article