CARA BUAT LINK DI EXCEL DENGAN 2 FILE

Link sharing is a common activity we do in our daily life. If you are someone who frequently uses messaging apps, then you probably know the importance of sharing links. Sharing links can sometimes become difficult when you have to share a link to someone who is not in your contact list or with whom you haven’t communicated before. This is particularly the case with social media platforms like Telegram. In this article, we will show you how to create a link to Telegram without sharing your phone number.

Cara Buat Link Telegram Tanpa Nombor Phone

If you are someone who likes to keep their privacy intact, then this method is perfect for you. To create a Telegram link without sharing your phone number, you can follow these simple steps:

  1. Open the Telegram app on your device
  2. Click on the three horizontal lines on the top left corner of the screen
  3. Go to “New Group” or “New Channel” depending on which one you want to create the link for
  4. Enter the relevant details (group name, channel name) and press on the “Create” button
  5. Now, go back to the main screen of Telegram and click on the search bar
  6. Type the name of the group/channel you just created
  7. Once you find it, click on the name to open the conversation
  8. On the top right corner of the screen, you will see a vertical three-dot icon. Click on it
  9. Select “Manage Group” or “Manage Channel” depending on which one you are using
  10. Scroll down until you see the “Invite Link” option and click on it
  11. Now, you will see the link that you can share with anyone without sharing your phone number
Baca Juga :  Cara Membuat Row Tetap Di Excel

Cara Membuka File Excel yang Terkunci Tanpa Aplikasi

Excel is a popular tool for data analysis and management. However, sometimes we forget the password we set for our Excel file, making it inaccessible. In this section, we will show you how to unlock a locked Excel file without using any third-party applications. Follow these steps:

  1. Open the Excel file you want to unlock
  2. Press “Alt + F11” to open the VBA editor
  3. Click on “Insert” from the menu and select “Module”
  4. Paste the following code in the blank space:
Sub PasswordBreaker()
    'Breaks worksheet password protection.

    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & i1 & i2 & i3 & i4 & i5 & i6 & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & i1 & i2 & i3 & _
            i4 & i5 & i6 & Chr(n)
         Exit Sub

    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub
  1. Close the VBA editor and go back to the worksheet
  2. Press “Alt + F8” and select the macro named “PasswordBreaker”
  3. Click on “Run” to execute the macro
  4. The macro will run and find the password. Once it finds the password, it will display it on the screen
  5. Use the password to unlock the worksheet
  6. Save the Excel file with a new password to protect it in the future
Baca Juga :  Cara Membuat Tabel Pada Microsoft Excel 2007

Cara Buat Shortcut Link Web Dengan Mudah & Cepat

Creating shortcuts to your favorite websites can save you time and effort. Instead of typing the full URL in the address bar every time you want to open a webpage, you can create a shortcut on your desktop or in your bookmarks. In this section, we will show you how to create shortcuts to any website you want with just a few clicks.

  1. Open the website you want to create a shortcut for
  2. Click and hold on the URL in the address bar and drag it onto your desktop or into a folder
  3. A shortcut will be created on your desktop or in the folder
  4. You can rename the shortcut by right-clicking on it and selecting “Rename”
  5. To create a shortcut in your bookmarks:
  6. Open the website you want to create a shortcut for
  7. Click on the three dots on the top right corner of the screen
  8. Select “Bookmark This Page”
  9. Choose the folder where you want to save the bookmark
  10. If you want to customize the name of the bookmark, you can do so by clicking on the text field next to “Name”
  11. Click on “Done” to save the bookmark

Cara Buat Link Text dan Link Gambar Lengkap

Links can be inserted as text or images on your website or blog. In this section, we will show you how to create a link using text and an image with detailed steps.

Cara Buat Link Text

  1. Select the text you want to create a link for
  2. Click on the “Insert Link” button or press “Ctrl + K” (Windows) or “Cmd + K” (Mac)
  3. Enter the URL you want to link to in the “Link” text field
  4. If you want to open the link in a new tab, select “New Window” from the “Target” dropdown menu
  5. Click on “Apply” to add the link to your text
Baca Juga :  Cara Mengekspor Data Excel Ke Format Text

Cara Buat Link Gambar

  1. Select the image you want to create a link for
  2. Click on the “Insert Link” button
  3. Enter the URL you want to link to in the “URL” text field
  4. If you want to open the link in a new tab, select “New Window” from the “Target” dropdown menu
  5. Click on “Insert” to add the link to your image

FAQs

Q. Can I use Telegram without sharing my phone number?

A. Yes, you can use Telegram without sharing your phone number. However, you will need to create a new account with a fake phone number or use a phone number that is not associated with your identity.

Q. How to unlock a password-protected Excel file?

A. You can unlock a password-protected Excel file by using VBA editor. Simply follow the steps provided in this article to unlock your Excel file.

Conclusion

Link sharing, unlocking password-protected Excel files, and creating shortcuts to your favorite websites are all handy skills to have. The methods provided in this article are easy to follow and do not require any third-party applications. We hope that this article has been helpful to you and has provided you with valuable insights into how to tackle these common tasks.

Feel free to share this article with your friends and colleagues. If you have any queries or feedback, please don’t hesitate to let us know.