.......................................................................... ....................................................................... ......................................................................
Showing posts with label MS-Office Tips. Show all posts
Showing posts with label MS-Office Tips. Show all posts

Saturday, 1 June 2013

Did our first glimpse of Metro Office apps just appear in Microsoft's Windows 8.1 pics?





Microsoft let many cats out of myriad bags in its whopping 1,817-word reveal of Windows 8.1 yesterday, but it's what the company didn't talk about that's almost more intriguing. Mixed in among all the chatter was a curious screenshot of the Windows 8.1 Start screen, and tucked away in amongst its Live Tiles were four eye-opening squares.


Folks, I think we just got our first look at modern-style Office apps. Or at least their Live Tiles.



Modern Office apps


 

Check out the image above, from Microsoft’s own Windows 8.1 blog post. Word, Excel, PowerPoint, and OneNote all make an appearance, positioned there next to the SkyDrive app.

So what, you ask? Microsoft owns Office! Indeed it does—but Microsoft does not offer modern UI versions of its core Office programs. Word, Excel, PowerPoint, and OneNote are only offered as desktop programs as of today. And pinning those desktop productivity programs to the Windows 8 Start screen creates tiles with the same light blue background as any other desktop app—and not the colorful squares shown in Microsoft's blog post.

Microsoft does offer a modern app for its Lync communications software, though, and its Start screen tile bears a striking resemblance to the Office app tiles in the Windows 8.1 blog post, from the simple colors to the "open book"-style design.



In the screenshot to the right, you’ll see tiles of Microsoft’s modern Lync app alongside tiles for the core Office desktop programs, all from my Windows 8 Start screen. See what I mean? 





Now, the appearance of colored Office tiles in Microsoft's blog post could just mean that we’ll have the ability to choose background color for tiles derived from desktop programs, which would be pretty cool in and of itself. (Update: And apparently the case, according to Foley's Tweet. Microsoft's blog post and the subsequent coverage said nothing about customizable tile colors, so hey, the appearance of those tiles nonetheless brought something new to light. -Brad) 





But consider that no other desktop program was shown in any of Microsoft’s Windows 8.1 screenshots... and the four tiles' close resemblence to the Lync app's tile, and the Start screen tiles for Microsoft's other preinstalled such as Video, Music, and Maps... and that those intriguing  modern-style Office “Gemini” rumors  have been floating around.

Suddenly, the Office tiles in the Windows 8.1 screenshots start to look like a lot more than mere squares. We may know for sure soon. If the Gemini rumors hold true, modern-style Office apps may just land on Start screens around the globe later this year

Tuesday, 23 April 2013

EXCEL UNPROTECT SHEET TRICKS



EXCEL UNPROTECT SHEET TRICKS


 

1. Protect Excel Workbook:

 

 

2.  Press  ALT +  F11

 

 

3. Click on View --->  Code in Developers Tabs: 

 

 

        4.  In the Above White Space Enter the below Code. Do not change the code just copy paste:



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) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub



 


5.  Now Click on the Run Button or press F5:


       And there you go the sheet is unprotected for you now. Also you would be getting a message in the pop up window.

This Message is contains the password which can be used to unprotect the other sheets in the same workbook.

 

 

  

  Please visit video link:  

 

DOWNLOAD LINK:   EXCEL UNPROTECT SHEET TRICKS.MP4


                                                                               நன்à®±ி.

 
Design by New Themes | Bloggerized by KarunKuyill - KarunKuyill | All-in-One Website
back to top