tag:blogger.com,1999:blog-57391964893775442282024-02-19T23:32:12.966+01:00RunakaySolutions for problems in Linux, Windows and Android. Posts that will make your life easier in a computer or smartphone.Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.comBlogger93125tag:blogger.com,1999:blog-5739196489377544228.post-52124815640918600672023-04-08T13:54:00.002+02:002023-04-08T14:11:32.420+02:00Unbrick or Recover Xiaomi Redmi 10A and other MTK devices<p><b>Case:</b> Your Redmi 10A (probably other MTK devices too) is not turning on and doesn't react to any button pressed nor cable connection.</p><p><b>Requisites:</b> </p><ul style="text-align: left;"><li>Dead phone <br /></li><li>USB Cable </li><li>You tried tons of tutorials to unbrick the phone and didn't work<br /></li><li><a href="https://androidfilehost.com/?fid=15664248565197184488" target="_blank">This image</a> <br /></li><li>Willingness to even use Linux to fix it (it's not hard)<br /></li></ul><p><b>Steps:</b><br /></p><ul style="text-align: left;"><li>Create a bootable USB using the image downloaded.</li><li>Make sure your computer allows booting from USB.</li><li>Boot the computer from the bootable USB.</li><li>When booting, a list of options will be shown. Pick the first one: Boot Live system.</li><li>Once the system is loaded, go to the right-upper corner to connect to Wi-Fi.</li><li>Once you have internet, use the Firefox browser (click on the icon in the left-upper corner) and download the Linux version of <a href="https://spflashtool.com/download/" target="_blank">this tool</a> (SP Flash) and save it in the desktop.</li><li>Unzip the tool downloaded.</li><li>Download the fastboot version of the <a href="https://miuirom.org/phones/redmi-10a" target="_blank">stock ROM</a>.</li><li>Unzip the ROM, to have the folder and files.<br /></li><li>Click on 'MTK' icon that is in the desktop.</li><li>In the command line opened, run this command: python mtk payload</li><li>Connect the phone with the USB cable and keep pressed the volume up and down at the same time until you see that the command line detects the phone.</li><li>Let the command finish.</li><li>Open the folder of the SP Flash and look for the file 'flash tool.sh'.</li><li>Drag and drop this file to the terminal window, and hit enter in the keyboard.</li><li>SP Flash starts.</li><li>In the tool, go to 'Options' - 'Option... ' and in 'Connection' pick 'UART', close the window.</li><li>Go to 'Download' tab and load the scatter file (inside 'Images' folder in the ROM folder).</li><li>Click 'Download' and wait for the tool to finish.</li><li>Disconnect the USB cable and turn on the phone.</li></ul><p><b>Results: </b>The phone is turning on and loading the stock ROM. </p><p><br /></p>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com2tag:blogger.com,1999:blog-5739196489377544228.post-47166498431678271482022-01-30T15:37:00.002+01:002022-01-30T15:40:26.079+01:00Clear Automatically Microsoft Teams Cache<p></p><p><b>Case:</b> You want to delete periodically the cache files of <a href="https://www.microsoft.com/fr-fr/microsoft-teams/group-chat-software" target="_blank">Microsoft Teams</a> to make it lighter.<br /></p><div style="text-align: justify;"><div style="text-align: justify;">
<b>Requisites:</b> Microsoft Teams cache folder path. You can find it by going to your user folder and then go to 'AppData\Roaming\Microsoft\teams\Code Cache'.<br /></div><div style="text-align: justify;"><br /><b>Steps:</b><br /></div>
<ul style="text-align: justify;"><li style="line-height: 1;">Go to 'Task Manager':<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjy54fX8C_B9zUxt-aRFJ8Sw1rQ15wEf4v_65DxyzLogjpLsOKw8lNjJDJQY-V5t9a-mjRdugafvZBL_EjfUMf5hazuseA8m2t_7BzTOP-6PVy4W6gwITMz03PxOYQu0TYoJFdDIIvAGTIXDxkW8Wrc4Wj8pmqxj0XLp_fRyTjs2Htfxr6Kkl_34mPE=s1475" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to Task Manager" border="0" data-original-height="1009" data-original-width="1475" height="438" src="https://blogger.googleusercontent.com/img/a/AVvXsEjy54fX8C_B9zUxt-aRFJ8Sw1rQ15wEf4v_65DxyzLogjpLsOKw8lNjJDJQY-V5t9a-mjRdugafvZBL_EjfUMf5hazuseA8m2t_7BzTOP-6PVy4W6gwITMz03PxOYQu0TYoJFdDIIvAGTIXDxkW8Wrc4Wj8pmqxj0XLp_fRyTjs2Htfxr6Kkl_34mPE=w640-h438" title="Go to Task Manager" width="640" /></a></div><br /><br /></li><li style="line-height: 1;">Right click on 'Task Scheduler' and click on 'Create Task...':<br /><br /><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjzEQxjSDABNP48JmFBULsfUu8Db6YeKvQBhwB6AA3aaqFtvAQylnVdVWtHRJY84qi-L6ZMVvz_KYU7zJ_eYlgBhF19ujzRbVbhs9pWrCz3ZDZcgDp3X5if2aj3n9bFhOQSpSMGFWBXmhc6Uw3S2riMKTL1LbsFpTzUwZCSDOUVX-q-IAqk4VCPgB7e=s650" style="margin-left: 1em; margin-right: 1em;"><img alt="Create task" border="0" data-original-height="522" data-original-width="650" height="321" src="https://blogger.googleusercontent.com/img/a/AVvXsEjzEQxjSDABNP48JmFBULsfUu8Db6YeKvQBhwB6AA3aaqFtvAQylnVdVWtHRJY84qi-L6ZMVvz_KYU7zJ_eYlgBhF19ujzRbVbhs9pWrCz3ZDZcgDp3X5if2aj3n9bFhOQSpSMGFWBXmhc6Uw3S2riMKTL1LbsFpTzUwZCSDOUVX-q-IAqk4VCPgB7e=w400-h321" title="Create task" width="400" /></a> <br /></div><br /><br /></li><li style="line-height: 1;">Put a name for the task, set some options and click on 'OK':<br /><br /><br /><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhTSAPSCc8A5mVJyb6cIlrAt8raHiFwYtGnLHGe9PE4wR8s8tiLrfq5Fhzx6tEw4VoA1wEkSUtnVtdhgSd-B2GBKb7isYzJ_fsmQ2EhHeCbluV07oHvVcztlg_MKMK0YEbAgl5ojEKXpV6Y99hL-riN3HF3wp4gbLgSPDQIRelOOmYno-g9CBetqVry=s960" style="margin-left: 1em; margin-right: 1em;"><img alt="Put name and set options" border="0" data-original-height="734" data-original-width="960" height="490" src="https://blogger.googleusercontent.com/img/a/AVvXsEhTSAPSCc8A5mVJyb6cIlrAt8raHiFwYtGnLHGe9PE4wR8s8tiLrfq5Fhzx6tEw4VoA1wEkSUtnVtdhgSd-B2GBKb7isYzJ_fsmQ2EhHeCbluV07oHvVcztlg_MKMK0YEbAgl5ojEKXpV6Y99hL-riN3HF3wp4gbLgSPDQIRelOOmYno-g9CBetqVry=w640-h490" title="Put name and set options" width="640" /></a><a href="https://1.bp.blogspot.com/-9fGt4kHzOx0/YWMIQNmyP9I/AAAAAAAADCU/hJNLrBLAv8kpnDI2Mp1bhfBMGChBqs0WACLcBGAsYHQ/s1021/TreeViewSharepoint4.png" style="margin-left: 1em; margin-right: 1em;"> <br /></a></div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-PvpgwsK-UNc/YZ_bN8Ew2PI/AAAAAAAADFE/lwBDsF3f_k0eBd11mSwDC2KZnMtEuaO9ACLcBGAsYHQ/s1021/TreeViewSharepoint4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Pages in the navigation bar" border="0" data-original-height="90" data-original-width="1021" height="56" src="https://1.bp.blogspot.com/-PvpgwsK-UNc/YZ_bN8Ew2PI/AAAAAAAADFE/lwBDsF3f_k0eBd11mSwDC2KZnMtEuaO9ACLcBGAsYHQ/w640-h56/TreeViewSharepoint4.webp" title="Pages in the navigation bar" width="640" /></a> <br /></div><br /><br /></li><li style="line-height: 1;">Under 'Triggers', create or edit a trigger:<br /><br /><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjV_Q9TS-_WrQ4drP8YFEproSQlAryYkuxZEF5JlTmP2SNv-eSMWq9PsuWMFsMec8G3EMSqYFsMM_4BEdVuZ9jrywP1oVuZUt079UAwLjeWPuUkcfQk-DKzBrkfYIgumIh3ior6Qhu8baaM7tZHJxI7sNc8IgpJitZAxzvLHPtljTS4clys54rEUOBh=s962" style="margin-left: 1em; margin-right: 1em;"><img alt="Create or edit a trigger" border="0" data-original-height="730" data-original-width="962" height="486" src="https://blogger.googleusercontent.com/img/a/AVvXsEjV_Q9TS-_WrQ4drP8YFEproSQlAryYkuxZEF5JlTmP2SNv-eSMWq9PsuWMFsMec8G3EMSqYFsMM_4BEdVuZ9jrywP1oVuZUt079UAwLjeWPuUkcfQk-DKzBrkfYIgumIh3ior6Qhu8baaM7tZHJxI7sNc8IgpJitZAxzvLHPtljTS4clys54rEUOBh=w640-h486" title="Create or edit a trigger" width="640" /></a> <br /></div><div style="text-align: center;"> <br /></div> <br /><br /></li><li style="line-height: 1;">Set the frequency for the trigger execution and enable it:<br /><br /><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiqns32Li6dcBZ_YjaFm8GOfXECQ5ienW__1xY90iNFqIyM5z_W7jpaRCDaL7LpZWQvkLrbdsDSEHr_C7HN24tRJesUhHjGP2ZcDfx0n-R2XJARx6YRPBUeUKLYlxsJQ3VUgwkg0fRsNAWZR3tC1EhnT_8T3AdA_3Sc2efIko6GZGHwHwqvrhBnQxxr=s907" style="margin-left: 1em; margin-right: 1em;"><img alt="Set frequency and enable it" border="0" data-original-height="792" data-original-width="907" height="558" src="https://blogger.googleusercontent.com/img/a/AVvXsEiqns32Li6dcBZ_YjaFm8GOfXECQ5ienW__1xY90iNFqIyM5z_W7jpaRCDaL7LpZWQvkLrbdsDSEHr_C7HN24tRJesUhHjGP2ZcDfx0n-R2XJARx6YRPBUeUKLYlxsJQ3VUgwkg0fRsNAWZR3tC1EhnT_8T3AdA_3Sc2efIko6GZGHwHwqvrhBnQxxr=w640-h558" title="Set frequency and enable it" width="640" /></a></div><br /></li><li style="line-height: 1;">Under 'Actions', create or edit an action:<br /><br /><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhdVQWhEo6rBtPr7HX3VN7VxTvcsGD6BnJJcrFjdkRly84YaPhR-HJx35GyiIxw2Jhsk6JIvCyWOCdxY-FmFRrLefxOGHSDHqd9pQEBELEe4eP74wY683TH5ArbaedXP33zvGzWIFSLUKFDwnQYsVy4KKRblSL7aJNQOj1QT10SkSPmDu-2V-DyKDIL=s956" style="margin-left: 1em; margin-right: 1em;"><img alt="Create or edit an action" border="0" data-original-height="735" data-original-width="956" height="492" src="https://blogger.googleusercontent.com/img/a/AVvXsEhdVQWhEo6rBtPr7HX3VN7VxTvcsGD6BnJJcrFjdkRly84YaPhR-HJx35GyiIxw2Jhsk6JIvCyWOCdxY-FmFRrLefxOGHSDHqd9pQEBELEe4eP74wY683TH5ArbaedXP33zvGzWIFSLUKFDwnQYsVy4KKRblSL7aJNQOj1QT10SkSPmDu-2V-DyKDIL=w640-h492" title="Create or edit an action" width="640" /></a></div><br /></li><li style="line-height: 1;">Pick 'Start a program' as action, type 'cmd' as program and add as arguments: <blockquote>/c "del /Q /S "C:\Users\<your_username>\AppData\Roaming\Microsoft\teams\Code Cache\*" </blockquote><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiX4AwsXqQW7BwuWobGx3g431MxZ26Sijs5Hqp83oDKw3TAUEXPwm6Zwo1tya_iYWEmUDrhEZSm1QUA1M8Oq5FJPWSWYHqbRRxmLbIDG6WnbVmGDjEJzYd3Omr7KvrwzLKJiuZLhEUwt56bnhfhG_mBs8vUyLPToPTDCJKpo0uDfV7O2ah7JOQ57WgO=s764" style="margin-left: 1em; margin-right: 1em;"><img alt="Start a program" border="0" data-original-height="764" data-original-width="689" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEiX4AwsXqQW7BwuWobGx3g431MxZ26Sijs5Hqp83oDKw3TAUEXPwm6Zwo1tya_iYWEmUDrhEZSm1QUA1M8Oq5FJPWSWYHqbRRxmLbIDG6WnbVmGDjEJzYd3Omr7KvrwzLKJiuZLhEUwt56bnhfhG_mBs8vUyLPToPTDCJKpo0uDfV7O2ah7JOQ57WgO=w361-h400" title="Start a program" width="361" /></a><br /></div><div style="text-align: center;"></div><div style="text-align: center;"> <br /></div></li></ul><p style="text-align: left;"><b>Results: </b>The cache files of Microsoft Teams will be clear automatically on the frequency scheduled. <br /></p><p style="text-align: center;"> </p></div>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-17104240130308131092021-10-10T17:53:00.002+02:002021-11-25T20:01:39.939+01:00Create a Tree View for Your Pages in Sharepoint<p><b>Case:</b> You have some pages in <a href="https://www.microsoft.com/fr-fr/microsoft-365/sharepoint/collaboration" target="_blank">Sharepoint</a> that you want to present as a tree due to the parent-child relationship between them.<br /></p><div style="text-align: justify;"><div style="text-align: justify;">
<b>Requisites:</b> Pages created in Sharepoint.<br /></div><div style="text-align: justify;"><br /><b>Steps:</b><br /></div>
<ul style="text-align: justify;"><li style="line-height: 1;">Open each page and use the 'Promote' option:<br /><br /><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-Y_3Q3zQR6r4/YZ_bN4JM5bI/AAAAAAAADFI/Uyg6nziiRkoEHVkVy2bmyYCILD24TF7LgCLcBGAsYHQ/s877/TreeViewSharepoint2.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Promote the page" border="0" data-original-height="483" data-original-width="877" height="352" src="https://1.bp.blogspot.com/-Y_3Q3zQR6r4/YZ_bN4JM5bI/AAAAAAAADFI/Uyg6nziiRkoEHVkVy2bmyYCILD24TF7LgCLcBGAsYHQ/w640-h352/TreeViewSharepoint2.webp" title="Promote the page" width="640" /></a></div><br /></div><br /><br /></li><li style="line-height: 1;">Click on 'Add page to navigation':<br /><br /><br /><div style="text-align: center;"></div><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-TX0rqkbolss/YZ_bNwhJCPI/AAAAAAAADFM/uWGRZxNMocQXxAAdF3Qk1rcF9jZkQvmLACLcBGAsYHQ/s466/TreeViewSharepoint3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Add page to navigation" border="0" data-original-height="327" data-original-width="466" height="281" src="https://1.bp.blogspot.com/-TX0rqkbolss/YZ_bNwhJCPI/AAAAAAAADFM/uWGRZxNMocQXxAAdF3Qk1rcF9jZkQvmLACLcBGAsYHQ/w400-h281/TreeViewSharepoint3.webp" title="Add page to navigation" width="400" /></a> <br /></div><br /><br /></li><li style="line-height: 1;">You will have all the pages shown in the navigation bar:<br /><br /><br /><div style="text-align: center;"></div><div style="text-align: center;"></div><div style="text-align: center;"></div><div style="text-align: center;"></div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-9fGt4kHzOx0/YWMIQNmyP9I/AAAAAAAADCU/hJNLrBLAv8kpnDI2Mp1bhfBMGChBqs0WACLcBGAsYHQ/s1021/TreeViewSharepoint4.png" style="margin-left: 1em; margin-right: 1em;"> </a></div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-PvpgwsK-UNc/YZ_bN8Ew2PI/AAAAAAAADFE/lwBDsF3f_k0eBd11mSwDC2KZnMtEuaO9ACLcBGAsYHQ/s1021/TreeViewSharepoint4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Pages in the navigation bar" border="0" data-original-height="90" data-original-width="1021" height="56" src="https://1.bp.blogspot.com/-PvpgwsK-UNc/YZ_bN8Ew2PI/AAAAAAAADFE/lwBDsF3f_k0eBd11mSwDC2KZnMtEuaO9ACLcBGAsYHQ/w640-h56/TreeViewSharepoint4.webp" title="Pages in the navigation bar" width="640" /></a> <br /></div><br /><br /></li><li style="line-height: 1;">Edit the navigation bar and click '...', 'Make sub link' for the page that you want to be a child of the previous page in the navigation bar:<br /><br /><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-s3bc0cSCHb4/YZ_bOj6rTPI/AAAAAAAADFQ/8Xkkr1mM2GoX42_MSB22NUYS0grszyIHACLcBGAsYHQ/s521/TreeViewSharepoint5.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Make page a child page" border="0" data-original-height="521" data-original-width="387" height="400" src="https://1.bp.blogspot.com/-s3bc0cSCHb4/YZ_bOj6rTPI/AAAAAAAADFQ/8Xkkr1mM2GoX42_MSB22NUYS0grszyIHACLcBGAsYHQ/w298-h400/TreeViewSharepoint5.webp" title="Make page a child page" width="298" /></a> <br /></div> <br /><br /></li><li style="line-height: 1;">Repeat the steps until you see the structure you want and save it:<br /><br /><br /><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-8xeeS6LzX4s/YZ_bO_7i8YI/AAAAAAAADFU/68haTev90AYbYHJGY69kGIz_Vd7RvtKqgCLcBGAsYHQ/s428/TreeViewSharepoint6.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Parents and children pages in navigation bar" border="0" data-original-height="428" data-original-width="245" height="400" src="https://1.bp.blogspot.com/-8xeeS6LzX4s/YZ_bO_7i8YI/AAAAAAAADFU/68haTev90AYbYHJGY69kGIz_Vd7RvtKqgCLcBGAsYHQ/w229-h400/TreeViewSharepoint6.webp" title="Parents and children pages in navigation bar" width="229" /></a> <br /></div></li></ul><p><b><br />Results: </b>The pages will look as parents and children in the navigation bar:</p><p style="text-align: center;"> </p><p style="text-align: center;"><a href="https://1.bp.blogspot.com/-FdGOYzUYBXY/YZ_bO_FmCCI/AAAAAAAADFY/U_M6JBDKUKUz-Rx6JbnGhT7TKyftUmPFACLcBGAsYHQ/s575/TreeViewSharepoint7.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Final structure for pages" border="0" data-original-height="122" data-original-width="575" height="136" src="https://1.bp.blogspot.com/-FdGOYzUYBXY/YZ_bO_FmCCI/AAAAAAAADFY/U_M6JBDKUKUz-Rx6JbnGhT7TKyftUmPFACLcBGAsYHQ/w640-h136/TreeViewSharepoint7.webp" title="Final structure for pages" width="640" /></a> </p><p style="text-align: center;"><br /></p><p><b></b></p></div>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-35962651327443923972021-08-08T21:10:00.001+02:002021-11-25T20:10:42.120+01:00Download Video Transcript from Microsoft Stream<p><b>Case:</b> You have a video in <a href="https://www.microsoft.com/fr-fr/microsoft-365/microsoft-stream" target="_blank">Microsoft Stream</a> with transcription enabled and you want to download the transcript.<br /></p><div style="text-align: justify;"><div style="text-align: justify;">
<br />
<b>Requisites:</b> Video in Microsoft Stream with transcription enabled.<br /></div><div style="text-align: justify;"><br /><b>Steps:</b><br /></div>
<ul style="text-align: justify;"><li style="line-height: 1;">Open the video in Microsoft Stream.<br /><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-jalckQ5tsZ8/YZ_e1FsBAvI/AAAAAAAADF0/18kzNBOTGNYFsv6l7_0mdFDgSxVkj3gkQCLcBGAsYHQ/s1474/Transcript1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="See video in Microsoft Stream" border="0" data-original-height="832" data-original-width="1474" height="362" src="https://1.bp.blogspot.com/-jalckQ5tsZ8/YZ_e1FsBAvI/AAAAAAAADF0/18kzNBOTGNYFsv6l7_0mdFDgSxVkj3gkQCLcBGAsYHQ/w640-h362/Transcript1.webp" title="See video in Microsoft Stream" width="640" /></a></div><br /><br /></li><li style="line-height: 1;">Click on '...' and 'Update video details'.<br /><br /><br /><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-ElNwjW2xgp4/YZ_e1Mgo9nI/AAAAAAAADFs/UZsaPH55n78JO_fYQjQhFFZBPwc0mCr_gCLcBGAsYHQ/s986/Transcript2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Update video details in Microsoft Stream" border="0" data-original-height="836" data-original-width="986" height="542" src="https://1.bp.blogspot.com/-ElNwjW2xgp4/YZ_e1Mgo9nI/AAAAAAAADFs/UZsaPH55n78JO_fYQjQhFFZBPwc0mCr_gCLcBGAsYHQ/w640-h542/Transcript2.webp" title="Update video details in Microsoft Stream" width="640" /></a></div><br /><br /></li><li style="line-height: 1;">Click on 'Download file' under the 'Options' section and save the vtt file.<br /><br /><br /><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-BYXVPiKfIsI/YZ_e1d4QuTI/AAAAAAAADFw/qvdSD4mZbcIRm11jjznOIhnnP2o1mBHpACLcBGAsYHQ/s1394/Transcript3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Download transcript from Microsoft Stream" border="0" data-original-height="724" data-original-width="1394" height="332" src="https://1.bp.blogspot.com/-BYXVPiKfIsI/YZ_e1d4QuTI/AAAAAAAADFw/qvdSD4mZbcIRm11jjznOIhnnP2o1mBHpACLcBGAsYHQ/w640-h332/Transcript3.webp" title="Download transcript from Microsoft Stream" width="640" /></a></div><br /><br /></li><li style="line-height: 1;">Go to <a href="https://web.microsoftstream.com/VTTCleaner/CleanVTT.html">https://web.microsoftstream.com/VTTCleaner/CleanVTT.html<br /><br /></a></li><li style="line-height: 1;">Upload the vtt file with the 'Choose Files' option. <br /><br /><br /><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-LVCqu_f7Wec/YZ_e1kPlu7I/AAAAAAAADF4/7zdu7lBGmbAf791iX7ER4-6c8eT3LHsmwCLcBGAsYHQ/s1104/Transcript4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Select file in Microsoft Stream transcript cleaner" border="0" data-original-height="520" data-original-width="1104" height="302" src="https://1.bp.blogspot.com/-LVCqu_f7Wec/YZ_e1kPlu7I/AAAAAAAADF4/7zdu7lBGmbAf791iX7ER4-6c8eT3LHsmwCLcBGAsYHQ/w640-h302/Transcript4.webp" title="Select file in Microsoft Stream transcript cleaner" width="640" /></a></div><br /></li></ul><p><b>Results: </b>The webpage will show the vtt formatted and ready to be copied, therefore, you can use the text as you wish.</p><p> <br /></p></div>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-30699785345514158152021-06-06T12:12:00.003+02:002022-01-23T16:23:22.011+01:00Stop Spam or Phishing Email Without Filtering<div style="text-align: justify;"><b>Case:</b> You receive spam or phishing in your email inbox and you want to avoid it without using the spam or phishing filter.<br /></div><div style="text-align: justify;">
<br />
<b>Requisites:</b> None.<br /></div><div style="text-align: justify;"><br /><b>Steps:</b><br /></div>
<ul style="text-align: justify;"><li style="line-height: 1;">Open the email in your inbox.<br /></li></ul><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiuGtYLk0rF9XtEhN8DRe3nzPlbSfFPBro-47OwnaP0MMVe73aGUCJXWcP7FXZGb74wJpfEI5gUEgySNg_r-tdVz0HGVFE7qW3-ohQuOJPdFMjbIMedC17axzQqwvAui1f-9F4aS5LSMEW92ME3mj-n7oFWBvoaigZ09XV9VI29LFE7ESHA1bf006n3=s945" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Open email in inbox" border="0" data-original-height="512" data-original-width="945" height="347" src="https://blogger.googleusercontent.com/img/a/AVvXsEiuGtYLk0rF9XtEhN8DRe3nzPlbSfFPBro-47OwnaP0MMVe73aGUCJXWcP7FXZGb74wJpfEI5gUEgySNg_r-tdVz0HGVFE7qW3-ohQuOJPdFMjbIMedC17axzQqwvAui1f-9F4aS5LSMEW92ME3mj-n7oFWBvoaigZ09XV9VI29LFE7ESHA1bf006n3=w640-h347" title="Open email in inbox" width="640" /></a></div></div><br /><ul style="text-align: justify;"><li style="line-height: 1;">Show email's header, in Gmail use the 'Show original' option. </li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgFvJwbKH00FF12apllyMh3JM7fpuUUXyOqQyW38-op9r2OAA3LkNH7i7vdxNBfqxsJjwXMdv9ReAhbtxmLWOPAK5YAflOaMOutJ_30s1rz6Haa4b8prOoofxJuI128HkH0BzHytfjkXXNxkH_xBlFavZEs-EeqvQsg3fwHjRMM5mLoKFn4Njy_VD-2=s922" style="margin-left: 1em; margin-right: 1em;"><img alt="Show email header" border="0" data-original-height="551" data-original-width="922" height="382" src="https://blogger.googleusercontent.com/img/a/AVvXsEgFvJwbKH00FF12apllyMh3JM7fpuUUXyOqQyW38-op9r2OAA3LkNH7i7vdxNBfqxsJjwXMdv9ReAhbtxmLWOPAK5YAflOaMOutJ_30s1rz6Haa4b8prOoofxJuI128HkH0BzHytfjkXXNxkH_xBlFavZEs-EeqvQsg3fwHjRMM5mLoKFn4Njy_VD-2=w640-h382" title="Show email header" width="640" /></a> <br /></div><p></p><ul style="text-align: justify;"><li style="line-height: 1;">In the header, find the 'Received: from' section and copy the IP address (last numbers between brackets).<br /><br /></li></ul><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgM32hLbDQFab2Ru-XCaUibNNhVY19pWaBmkXJU5oPzupws5Ziu_AkU0ujJI9dg_qiDLxqc2WClFIK04KCWbPNdzh2Zk2k81GzXw9wEp63mIT2W5Zn-qNN32TludDXIVJNoRlvY7TDuWTX-1hwiOiGiXMZ59novAv5_sn3Ilp_86eezazeXLOd8Ps5t=s1120" style="margin-left: 1em; margin-right: 1em;"><img alt="Find received in header" border="0" data-original-height="541" data-original-width="1120" height="310" src="https://blogger.googleusercontent.com/img/a/AVvXsEgM32hLbDQFab2Ru-XCaUibNNhVY19pWaBmkXJU5oPzupws5Ziu_AkU0ujJI9dg_qiDLxqc2WClFIK04KCWbPNdzh2Zk2k81GzXw9wEp63mIT2W5Zn-qNN32TludDXIVJNoRlvY7TDuWTX-1hwiOiGiXMZ59novAv5_sn3Ilp_86eezazeXLOd8Ps5t=w640-h310" title="Find received in header" width="640" /></a><br /><br /></div><ul style="text-align: justify;"><li style="line-height: 1;">Go to <a href="https://check-host.net/ip-info">https://check-host.net/ip-info</a>, put the IP in the textbox and click on 'Info'.<br /><br /></li></ul><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEg__mMcjgQVyNDNqS2UEpE2SzYxm4Asg8-25nq5tfuk6EOJNsHcPomz5HudfEs4PnZZxQ_p9NBf3h4EXCbCwGHVZ3vyxfjfiDhhBbObGlF8544LorgszkOKRpfnJZkxsa_rklthWgJaW98X18RGEpcRah1zjauMzV8hgTCeN9pw84X8H-xSsqvNkdq0=s852" style="margin-left: 1em; margin-right: 1em;"><img alt="Put IP address" border="0" data-original-height="463" data-original-width="852" height="348" src="https://blogger.googleusercontent.com/img/a/AVvXsEg__mMcjgQVyNDNqS2UEpE2SzYxm4Asg8-25nq5tfuk6EOJNsHcPomz5HudfEs4PnZZxQ_p9NBf3h4EXCbCwGHVZ3vyxfjfiDhhBbObGlF8544LorgszkOKRpfnJZkxsa_rklthWgJaW98X18RGEpcRah1zjauMzV8hgTCeN9pw84X8H-xSsqvNkdq0=w640-h348" title="Put IP address" width="640" /></a><br /><br /></div><ul style="text-align: justify;"><li style="line-height: 1;">Look for the 'Whois' section and click on 'Retrieve whois data'.<br /><br /></li></ul><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgWHqZOU4QCwMfaXQj0pz0IRmgGnEHLEyTmOVK8NmAcqlRZh6aO2fR-qme_uo4cQkLR0pbp-nnzDuKq5M6cpVL9QaVXmpNAQJZ7SeJiv8zE7D1aE0hVlImnUQaM8L9Jz13uzhzWeMUrb7HX8pXDm0oOONqhDBsFqn2UBMBDcX2qy_Jdr0-hojTwnY86=s818" style="margin-left: 1em; margin-right: 1em;"><img alt="Look for Whois section" border="0" data-original-height="457" data-original-width="818" height="358" src="https://blogger.googleusercontent.com/img/a/AVvXsEgWHqZOU4QCwMfaXQj0pz0IRmgGnEHLEyTmOVK8NmAcqlRZh6aO2fR-qme_uo4cQkLR0pbp-nnzDuKq5M6cpVL9QaVXmpNAQJZ7SeJiv8zE7D1aE0hVlImnUQaM8L9Jz13uzhzWeMUrb7HX8pXDm0oOONqhDBsFqn2UBMBDcX2qy_Jdr0-hojTwnY86=w640-h358" title="Look for Whois section" width="640" /></a><br /><br /></div><ul style="text-align: justify;"><li style="line-height: 1;">Look for any 'abuse' section where you can get the email to report the spam or phishing email.<br /><br /></li></ul><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhr3zrMn7ac9ICTZLwIAeUdCOsk0ofLQ1Xb2VUCym1Ulis_H5OGxWcbmBB_tEk9dg03HfgQ7WlGHax7_mxh5xc7CStBQzWEESGPojrlZIS5UUQoZ9mZ5RuKbDCWkN5TNiSCddrj0Ow6PZAJGRE9wS-I4iXd2asNwNJkju_VpWY7Btyv6mP9C8Dc-EsM=s833" style="margin-left: 1em; margin-right: 1em;"><img alt="Look for abuse section" border="0" data-original-height="389" data-original-width="833" height="298" src="https://blogger.googleusercontent.com/img/a/AVvXsEhr3zrMn7ac9ICTZLwIAeUdCOsk0ofLQ1Xb2VUCym1Ulis_H5OGxWcbmBB_tEk9dg03HfgQ7WlGHax7_mxh5xc7CStBQzWEESGPojrlZIS5UUQoZ9mZ5RuKbDCWkN5TNiSCddrj0Ow6PZAJGRE9wS-I4iXd2asNwNJkju_VpWY7Btyv6mP9C8Dc-EsM=w640-h298" title="Look for abuse section" width="640" /></a><br /><br /></div><ul style="text-align: justify;"><li style="line-height: 1;">Report the situation to the email you just found.<br /> <br /></li></ul><p><b>Results: </b>The IP that sent the email reported will stop sending spam or phishing emails. <br /><br /> <br /></p>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-55175024947226590932021-03-13T08:59:00.001+01:002021-11-25T20:35:14.050+01:00Create a Folder Grouping Messages From Different Accounts in Thunderbird<div style="text-align: justify;"><b>Case:</b> You have several accounts in <a href="https://www.thunderbird.net" target="_blank">Thunderbird</a> and you want to have one folder that will show you the messages from all the accounts. In this case the folder will show all the emails in the sent folder of each account that where sent in less than 7 days.<br /></div><div style="text-align: justify;">
<br />
<b>Requisites:</b> Thunderbird.<br /></div><div style="text-align: justify;"><br /><b>Steps:</b><br /></div>
<ul style="text-align: justify;"><li style="line-height: 1;">Go to 'Local Folders' and then to 'Search Messages...'.<br /> </li></ul><p></p><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-s_rmut2mYRM/YZ_jihF8i4I/AAAAAAAADGw/VYnfS-R8fhEmPPzFG2NYmJqjSNMv6bYrACLcBGAsYHQ/s316/VirtualFolder1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Search messages in local folders" border="0" data-original-height="261" data-original-width="316" height="330" src="https://1.bp.blogspot.com/-s_rmut2mYRM/YZ_jihF8i4I/AAAAAAAADGw/VYnfS-R8fhEmPPzFG2NYmJqjSNMv6bYrACLcBGAsYHQ/w400-h330/VirtualFolder1.webp" title="Search messages in local folders" width="400" /></a></div></div> <p></p><ul style="text-align: justify;"><li style="line-height: 1;">Click on 'Save as Virtual Folder'.<br /><div style="text-align: center;"><br /></div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-9K--7-D_siU/YEUj0j70JhI/AAAAAAAAC5U/-YqsNGzYsSkgMWk3RYwc0yLfdqf_eS3CgCLcBGAsYHQ/s499/VirtualFolder2.png" style="margin-left: 1em; margin-right: 1em;"> </a></div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-tMPsudtvd34/YZ_ji7V-_HI/AAAAAAAADG4/14QQSSbDVnwtIiy_ADVUzGmivY_y2t_gACLcBGAsYHQ/s499/VirtualFolder2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Save as Virtual Folder" border="0" data-original-height="342" data-original-width="499" height="274" src="https://1.bp.blogspot.com/-tMPsudtvd34/YZ_ji7V-_HI/AAAAAAAADG4/14QQSSbDVnwtIiy_ADVUzGmivY_y2t_gACLcBGAsYHQ/w400-h274/VirtualFolder2.webp" title="Save as Virtual Folder" width="400" /></a> <br /></div><div style="text-align: center;"><br /></div><br /></li><li style="line-height: 1;">Put a name to the new folder and click on 'Choose...'.<br /><br /><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-W76XQE4eCiU/YZ_jiwDg1VI/AAAAAAAADG0/QYIWUJvPdxMBE2D4mQLAzYb3C5uG4mUOgCLcBGAsYHQ/s779/VirtualFolder3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Choose the folders to search on" border="0" data-original-height="267" data-original-width="779" height="220" src="https://1.bp.blogspot.com/-W76XQE4eCiU/YZ_jiwDg1VI/AAAAAAAADG0/QYIWUJvPdxMBE2D4mQLAzYb3C5uG4mUOgCLcBGAsYHQ/w640-h220/VirtualFolder3.webp" title="Choose the folders to search on" width="640" /></a> <br /></div><div style="text-align: center;"><br /></div><br /></li><li style="line-height: 1;">Check the folders you want the messages to be collected from and click 'OK'.<br /><br /><div style="text-align: center;"><br /></div><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-w0tz7hyCQAk/YZ_jjZ9OhyI/AAAAAAAADG8/RP8_kH7RbREE-5ibmdVmKifC6HChZr_DACLcBGAsYHQ/s319/VirtualFolder4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Select first folder to search" border="0" data-original-height="267" data-original-width="319" height="335" src="https://1.bp.blogspot.com/-w0tz7hyCQAk/YZ_jjZ9OhyI/AAAAAAAADG8/RP8_kH7RbREE-5ibmdVmKifC6HChZr_DACLcBGAsYHQ/w400-h335/VirtualFolder4.webp" title="Select first folder to search" width="400" /></a> <br /></div><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-z04enhb8br4/YZ_jjeKabnI/AAAAAAAADHE/DRkNFdkaN-QoB0e21ouLmpiks5VlVTzkwCLcBGAsYHQ/s335/VirtualFolder5.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Select second folder to search" border="0" data-original-height="269" data-original-width="335" height="321" src="https://1.bp.blogspot.com/-z04enhb8br4/YZ_jjeKabnI/AAAAAAAADHE/DRkNFdkaN-QoB0e21ouLmpiks5VlVTzkwCLcBGAsYHQ/w400-h321/VirtualFolder5.webp" title="Select second folder to search" width="400" /></a> <br /></div><div style="text-align: center;"><br /></div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-UmObUHka5IM/YZ_jjcBVLgI/AAAAAAAADHA/9AoccXdbw1Elu4ym4mFs_WdHsVy8Pzx4ACLcBGAsYHQ/s331/VirtualFolder6.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Select OK to confirm folders" border="0" data-original-height="266" data-original-width="331" height="321" src="https://1.bp.blogspot.com/-UmObUHka5IM/YZ_jjcBVLgI/AAAAAAAADHA/9AoccXdbw1Elu4ym4mFs_WdHsVy8Pzx4ACLcBGAsYHQ/w400-h321/VirtualFolder6.webp" title="Select OK to confirm folders" width="400" /></a> <br /></div><div style="text-align: center;"><br /></div> </li><li style="line-height: 1;">Tick 'Search Online' and put the criteria, in this case all the messages that were sent less than 7 days. Then click on 'Update'.<br /><br /><br /><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-4b4eYcS5WmI/YZ_jjrWzU0I/AAAAAAAADHI/Ri6TiATzC0QpB2MYvfkoJHLiwWoQWPxkwCLcBGAsYHQ/s779/VirtualFolder8.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Define the criteria to search messages" border="0" data-original-height="269" data-original-width="779" height="222" src="https://1.bp.blogspot.com/-4b4eYcS5WmI/YZ_jjrWzU0I/AAAAAAAADHI/Ri6TiATzC0QpB2MYvfkoJHLiwWoQWPxkwCLcBGAsYHQ/w640-h222/VirtualFolder8.webp" title="Define the criteria to search messages" width="640" /></a> <br /></div><div style="text-align: center;"><br /></div></li></ul><p><b>Results:</b> The 'Sent' folder will be created and will show the messages in the folders defined that comply with the criteria.<br /><br /></p><p style="text-align: center;"><a href="https://1.bp.blogspot.com/-Zj1Uqet18n8/YZ_jj9W43kI/AAAAAAAADHM/ZXls5HOL_1QmeUWzdly61AHMgoEXaH_dwCLcBGAsYHQ/s258/VirtualFolder9.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="New virtual folder is listed" border="0" data-original-height="258" data-original-width="186" height="400" src="https://1.bp.blogspot.com/-Zj1Uqet18n8/YZ_jj9W43kI/AAAAAAAADHM/ZXls5HOL_1QmeUWzdly61AHMgoEXaH_dwCLcBGAsYHQ/w288-h400/VirtualFolder9.webp" title="New virtual folder is listed" width="288" /></a> <br /></p><p style="text-align: center;"> </p>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-4704297596317820272020-12-26T14:38:00.003+01:002021-11-25T20:56:18.447+01:00Set Custom Action in Right-Click Menu in Thunar<p></p><div style="text-align: justify;"><b>Case:</b> You want to create a custom action in <a href="https://docs.xfce.org/xfce/thunar/start" target="_blank">Thunar</a> so when you pick a file or folder and you right-click on it, you can have the action in the menu.<br /></div><div style="text-align: justify;">
<br />
<b>Requisites:</b> Thunar File Manager.<br /></div><div style="text-align: justify;"><br /><b>Steps:</b><br /></div>
<ul style="text-align: justify;"><li style="line-height: 1;">See the current right-click menu and validate that the custom action is not there.</li></ul><p></p><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-4I_Fh2WdGy0/YZ_m5oGyRmI/AAAAAAAADHk/96hltVpS4BUb5vuIEg8E6LOO3cbqSCuNwCLcBGAsYHQ/s679/Blog1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Menu that appears with right-click" border="0" data-original-height="589" data-original-width="679" height="348" src="https://1.bp.blogspot.com/-4I_Fh2WdGy0/YZ_m5oGyRmI/AAAAAAAADHk/96hltVpS4BUb5vuIEg8E6LOO3cbqSCuNwCLcBGAsYHQ/w400-h348/Blog1.webp" title="Menu that appears with right-click" width="400" /></a></div> </div><p></p><ul style="text-align: justify;"><li style="line-height: 1;">Go to 'Edition' in the toolbar and select 'Configure custom actions...'.<br /><br /><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-wWXdC12JEk4/YZ_m5iGIuJI/AAAAAAAADHg/fxJpDOGwAYs2bhrPe63tlRqHpL_MSJbdQCLcBGAsYHQ/s509/Blog2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Option in the menu to customize actions" border="0" data-original-height="368" data-original-width="509" height="289" src="https://1.bp.blogspot.com/-wWXdC12JEk4/YZ_m5iGIuJI/AAAAAAAADHg/fxJpDOGwAYs2bhrPe63tlRqHpL_MSJbdQCLcBGAsYHQ/w400-h289/Blog2.webp" title="Option in the menu to customize actions" width="400" /> </a></div><div style="text-align: center;"> <br /></div><br /></li><li style="line-height: 1;">Click '+' to add a new action.<br /><br /><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-vPsyWYsugd8/YZ_m5lZ70kI/AAAAAAAADHo/yQ_-GwK7h5YdV8l9i8VBqzlpK-PzCeq1QCLcBGAsYHQ/s683/Blog3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Add new action" border="0" data-original-height="447" data-original-width="683" height="261" src="https://1.bp.blogspot.com/-vPsyWYsugd8/YZ_m5lZ70kI/AAAAAAAADHo/yQ_-GwK7h5YdV8l9i8VBqzlpK-PzCeq1QCLcBGAsYHQ/w400-h261/Blog3.webp" title="Add new action" width="400" /> </a></div><div style="text-align: center;"> <br /></div><br /></li><li style="line-height: 1;">Put a name to display in the menu, a description, the command to execute when clicking, a shortcut and an icon.<br /><br /><div style="text-align: center;"> </div><div style="text-align: center;"><a href="https://1.bp.blogspot.com/-ThRg0O47unc/YZ_m6OjLz0I/AAAAAAAADHs/v5fQRYWOVWwpnvVkr3HFauGdrrQ2O6ovQCLcBGAsYHQ/s518/Blog4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Set the parameters for the new action" border="0" data-original-height="518" data-original-width="461" height="400" src="https://1.bp.blogspot.com/-ThRg0O47unc/YZ_m6OjLz0I/AAAAAAAADHs/v5fQRYWOVWwpnvVkr3HFauGdrrQ2O6ovQCLcBGAsYHQ/w356-h400/Blog4.webp" title="Set the parameters for the new action" width="356" /> </a></div><div style="text-align: center;"> <br /></div><br /></li><li style="line-height: 1;">Go to 'Appearance Conditions' tab, put 'File Pattern' and check for which types of items the action will appear and click 'OK'.<br /><br /><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-NvMAo-ti0XQ/YZ_m6SsXcfI/AAAAAAAADHw/i-W6blzTKqQzUvkPWrgtghAHQqyTeFRdwCLcBGAsYHQ/s516/Blog5.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Set the conditions for the action to show" border="0" data-original-height="516" data-original-width="460" height="400" src="https://1.bp.blogspot.com/-NvMAo-ti0XQ/YZ_m6SsXcfI/AAAAAAAADHw/i-W6blzTKqQzUvkPWrgtghAHQqyTeFRdwCLcBGAsYHQ/w356-h400/Blog5.webp" title="Set the conditions for the action to show" width="356" /> </a></div><div class="separator" style="clear: both; text-align: center;"> <br /></div></li></ul><p><b>Results:</b> When you right-click on an item and this fulfill the conditions, the custom action will be ready to use.<br /><br /></p><p style="text-align: center;"><a href="https://1.bp.blogspot.com/-48ggd2Nwu9U/YZ_m6RmIAzI/AAAAAAAADH0/tzFyvtq3oNAMg9iPtD01P14Qh-XgmjlAACLcBGAsYHQ/s602/Blog6.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="New custom action appears in the right-click menu" border="0" data-original-height="602" data-original-width="531" height="400" src="https://1.bp.blogspot.com/-48ggd2Nwu9U/YZ_m6RmIAzI/AAAAAAAADH0/tzFyvtq3oNAMg9iPtD01P14Qh-XgmjlAACLcBGAsYHQ/w353-h400/Blog6.webp" title="New custom action appears in the right-click menu" width="353" /></a> <br /></p><p style="text-align: center;"> </p>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-22859476551232589842020-10-30T21:51:00.003+01:002022-01-23T16:43:21.321+01:00Recover Your Facebook Page if you Cannot Locate the Administrator<b>Case:</b> Your Facebook page was managed by a former employee, you can't contact him and you want to recover the admin rights. <br /><div style="text-align: justify;">
<br />
<b>Requisites: </b>Active Facebook account and the URL of the Facebook page.<br /></div><div style="text-align: justify;"><br /><b>Steps:</b><br /></div>
<ul style="text-align: justify;"><li style="line-height: 1;">Go to this <a href="https://www.facebook.com/help/contact/634636770043106" target="_blank">page</a>.<br /></li></ul><ul style="text-align: justify;"><li style="line-height: 1;">As there is no a specific option for this case, pick 'Trademark' and then 'Continue with your trademark report'.</li></ul><p style="text-align: center;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgo6HiFd37HgbGDBGn4P6f8qTCZZh3quDdMHfH6rgOcGxEFfuYNgEyLSxS3kregSr0T8tAcy2Po2fGHCY_w5AkL0ZUqQcxAkG3V1pOtS2n1MYPPK7N2M0M-sIWwAQikcc-EOn81DQX77tMAYe-vX6zlrx1Mlaanyuzx81T9t4WUm45udFqhTVzFfyCN=s1366" style="margin-left: 1em; margin-right: 1em;"><img alt="Continue trademark report" border="0" data-original-height="460" data-original-width="1366" height="216" src="https://blogger.googleusercontent.com/img/a/AVvXsEgo6HiFd37HgbGDBGn4P6f8qTCZZh3quDdMHfH6rgOcGxEFfuYNgEyLSxS3kregSr0T8tAcy2Po2fGHCY_w5AkL0ZUqQcxAkG3V1pOtS2n1MYPPK7N2M0M-sIWwAQikcc-EOn81DQX77tMAYe-vX6zlrx1Mlaanyuzx81T9t4WUm45udFqhTVzFfyCN=w640-h216" title="Continue trademark report" width="640" /></a> <br /></div><p></p><ul style="text-align: justify;"><li style="line-height: 1;">Pick 'I found content which I believe infringes my trademark'.<br /></li></ul><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgUDY-p0zNMmLKfZW_LuU4TqZ-n5gtJja8N3MAxupB1Lcsyd1SogR2hBGAFy1H8Gn1GygE7dC897zO1y2KZgf1b0u1cxAauqvBvEaWT_x6i-ACsVtIQl4dR_8zX6TrMeGmXPvyw7aHmvpK0jBB_IleXWtvPb1pZXP26YAFeg6MnspeU8vvCDVpXYOgw=s1366" style="margin-left: 1em; margin-right: 1em;"><img alt="Pick I found content infriges trademark" border="0" data-original-height="648" data-original-width="1366" height="304" src="https://blogger.googleusercontent.com/img/a/AVvXsEgUDY-p0zNMmLKfZW_LuU4TqZ-n5gtJja8N3MAxupB1Lcsyd1SogR2hBGAFy1H8Gn1GygE7dC897zO1y2KZgf1b0u1cxAauqvBvEaWT_x6i-ACsVtIQl4dR_8zX6TrMeGmXPvyw7aHmvpK0jBB_IleXWtvPb1pZXP26YAFeg6MnspeU8vvCDVpXYOgw=w640-h304" title="Pick I found content infriges trademark" width="640" /></a> </p><ul style="text-align: justify;"><li style="line-height: 1;">Pick 'Continue with my trademark report'.<br /></li></ul><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEg0ARMbTB410CauntVF430Q8IYx_17i9vIDfvcaNKhwysiZEFqm4zaW4xigTZn4DBGQv27O2MGrpvmYJ9-66BSgl0nYuW-v3uw4ysRSiM-EOt5MjVk_lSBJU7iGqq0C5avvTgizGvJS0QqEspKQ4G9Szw_cKl3jjgaWbT0kTejLU58FOcKXGRM5MU01=s1366" style="margin-left: 1em; margin-right: 1em;"><img alt="Continue with trademark report" border="0" data-original-height="510" data-original-width="1366" height="238" src="https://blogger.googleusercontent.com/img/a/AVvXsEg0ARMbTB410CauntVF430Q8IYx_17i9vIDfvcaNKhwysiZEFqm4zaW4xigTZn4DBGQv27O2MGrpvmYJ9-66BSgl0nYuW-v3uw4ysRSiM-EOt5MjVk_lSBJU7iGqq0C5avvTgizGvJS0QqEspKQ4G9Szw_cKl3jjgaWbT0kTejLU58FOcKXGRM5MU01=w640-h238" title="Continue with trademark report" width="640" /></a> </p><ul style="text-align: justify;"><li style="line-height: 1;">Pick 'Provide your contact information', 'Me or my organization' and complete the information required.<br /></li></ul><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjMMaxqFMeSDyX_7wCtoWLdLXoiBu884GW0bus9tzBMG0VhJAKTDmOhE9VBf0wntwh2J_lWsWfwjkaIlHO-OJKjzU5qPQqd7mRJ36pnjrOoP10qv5pwJ27vSpovbyc6Zq8hZcENmRf8yYuVcIObAsoT2W6gNcxNq3SOXCHimvJ5ULUvBfEz4bMAtuMV=s1366" style="margin-left: 1em; margin-right: 1em;"><img alt="Provide contact information" border="0" data-original-height="650" data-original-width="1366" height="304" src="https://blogger.googleusercontent.com/img/a/AVvXsEjMMaxqFMeSDyX_7wCtoWLdLXoiBu884GW0bus9tzBMG0VhJAKTDmOhE9VBf0wntwh2J_lWsWfwjkaIlHO-OJKjzU5qPQqd7mRJ36pnjrOoP10qv5pwJ27vSpovbyc6Zq8hZcENmRf8yYuVcIObAsoT2W6gNcxNq3SOXCHimvJ5ULUvBfEz4bMAtuMV=w640-h304" title="Provide contact information" width="640" /></a> <br /></p><ul style="text-align: justify;"><li style="line-height: 1;">Pick 'Provide your trademark information' and complete the information required. </li></ul><p style="text-align: center;"></p><p style="text-align: center;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhBEkoTzNReouuw6GSd3pUtfN4ZXFMfzMSVWXh-JgKxv4BzEMBhoQ1dS3bgyvIyLu1690AS-3WNeEm6WaIz56Zj99zsBNc7sQWXk4cd55N2jKTul8huvDEYa5OMZegugAQP9fcEORffBR7rDFrK_tE7Xl-fVKRB8Y4Z1HYx7fPjTwS6omgBsatyBmoV=s1366" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Provide trademark information" border="0" data-original-height="659" data-original-width="1366" height="308" src="https://blogger.googleusercontent.com/img/a/AVvXsEhBEkoTzNReouuw6GSd3pUtfN4ZXFMfzMSVWXh-JgKxv4BzEMBhoQ1dS3bgyvIyLu1690AS-3WNeEm6WaIz56Zj99zsBNc7sQWXk4cd55N2jKTul8huvDEYa5OMZegugAQP9fcEORffBR7rDFrK_tE7Xl-fVKRB8Y4Z1HYx7fPjTwS6omgBsatyBmoV=w640-h308" title="Provide trademark information" width="640" /></a></div><br /><p></p><ul style="text-align: justify;"><li style="line-height: 1;">Pick 'Provide the content you want to report', 'An entire Page, group or profile' and provide the URL of your Facebook page you want to recover in the text box.<br /></li></ul><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgEzYCdW5dTP_MYf0fJiwfBW9qmVux-Bk-NKaFSBO7_wis8ItGw1ewYiwPPgsqUlDomIR4aXF4pS68ya5ahiqXKqMEazQovhZ8F6HKybsdMjS3R1dN2VCRZFDvpB-1JX2X6OZeXJJp6f9am3iPeyye_F_FN13_oDPTdoUTgp_NDDK6QUEg9OK2BElqJ=s1366" style="margin-left: 1em; margin-right: 1em;"><img alt="Provide the content you want to report" border="0" data-original-height="654" data-original-width="1366" height="306" src="https://blogger.googleusercontent.com/img/a/AVvXsEgEzYCdW5dTP_MYf0fJiwfBW9qmVux-Bk-NKaFSBO7_wis8ItGw1ewYiwPPgsqUlDomIR4aXF4pS68ya5ahiqXKqMEazQovhZ8F6HKybsdMjS3R1dN2VCRZFDvpB-1JX2X6OZeXJJp6f9am3iPeyye_F_FN13_oDPTdoUTgp_NDDK6QUEg9OK2BElqJ=w640-h306" title="Provide the content you want to report" width="640" /></a> <br /></p><p style="text-align: center;"> <br /></p><ul style="text-align: justify;"><li style="line-height: 1;">Below complete the text box under 'Please describe how you believe this content infringes your trademark rights.' explaining the reason you can't reach the former page administrator and that you want to have admin rights. Confirm the declaration, agree, sign and submit.</li></ul><p style="text-align: center;"> <a href="https://blogger.googleusercontent.com/img/a/AVvXsEiNB1Kodm_LFUUUvfJTwfgPum6UTYbz_jc7PR6Amh42fMLJXCQJnmX67lH5EhdIbmUjkBknUXD7jXeoHMcIamM9nLpdDZE7p_FVKmjMDML8LOvW6zlaqz53SY4ls8SfOELv3x7hCDKipmKQvCjYV2Usn9UtqIsSDsYIea0flhCyffaPbKB6t-3YS4yT=s1366" style="margin-left: 1em; margin-right: 1em;"><img alt="Confirm declaration" border="0" data-original-height="650" data-original-width="1366" height="304" src="https://blogger.googleusercontent.com/img/a/AVvXsEiNB1Kodm_LFUUUvfJTwfgPum6UTYbz_jc7PR6Amh42fMLJXCQJnmX67lH5EhdIbmUjkBknUXD7jXeoHMcIamM9nLpdDZE7p_FVKmjMDML8LOvW6zlaqz53SY4ls8SfOELv3x7hCDKipmKQvCjYV2Usn9UtqIsSDsYIea0flhCyffaPbKB6t-3YS4yT=w640-h304" title="Confirm declaration" width="640" /></a> <br /></p><ul style="text-align: justify;"><li style="line-height: 1;">You will receive an automatic email notifying the reception of the request.<br /> <br /></li><li style="line-height: 1;">A Facebook team will contact you to ask if you want to continue with the
request or to be forwarded to another team to help you with the page
administrator change.<br /><br /></li><li style="line-height: 1;">Request the page administrator change. </li></ul><div style="text-align: justify;"><b>Results:</b> You will be forwarded to a different team and they will help you to have your page back.<br /></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><br /></div>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-19980461291622385732020-08-22T19:23:00.004+02:002022-01-23T16:51:56.126+01:00Backup Outlook Web App E-mails to Another E-mail Account<div style="text-align: justify;"><b>Case:</b> You will stop using an e-mail account in Outlook Web App (OWA) and you need to backup your e-mails there to another account.<br /></div><div style="text-align: justify;">
<br />
<b>Requisites: </b>Access to your e-mail account in Outlook Web App and an active different e-mail account.<br /></div><div style="text-align: justify;"><br /><b>Steps:</b><br /></div>
<ul style="text-align: justify;"><li style="line-height: 1;">
Log in to the OWA account and click on <i>New mail</i>. <br /></li></ul><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjdw7P199W-mLGO00U8pzEymb9mELwjEBCmvn3mAPYqTr00e6kgzJWsNrH8CJ0vSrcsk7abFF60fHjPwOgS6Z-TUxBB9AVZNVfQFcwINJ4idUEj5_U6R8ucOUfI-etSUMQMyVSsYJ0SINi2dmPyJSbKFkpY8vC5OicDgd-l-G5-KOU5fEzkkB5foTPg=s610" style="margin-left: 1em; margin-right: 1em;"><img alt="Log into Outlook web" border="0" data-original-height="247" data-original-width="610" height="260" src="https://blogger.googleusercontent.com/img/a/AVvXsEjdw7P199W-mLGO00U8pzEymb9mELwjEBCmvn3mAPYqTr00e6kgzJWsNrH8CJ0vSrcsk7abFF60fHjPwOgS6Z-TUxBB9AVZNVfQFcwINJ4idUEj5_U6R8ucOUfI-etSUMQMyVSsYJ0SINi2dmPyJSbKFkpY8vC5OicDgd-l-G5-KOU5fEzkkB5foTPg=w640-h260" title="Log into Outlook web" width="640" /></a></div><br /></div><p></p><ul style="text-align: justify;"><li style="line-height: 1;">Put the 2 windows one next to the other.</li></ul><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjrx0s7f_r-28DrJ4XmeFRTHCtOge0wJ7b0YWqCFu-8-VzkALVEABPcICQk3V9ubrLCo8gKsmiEJSnZdSGGFyN_rtni6Y7tr213P0JVkQJgD2AF5qUY1h-6HNqO3l5FInYE2BS84RxXpUuF5GwHLnnKCulN9ey4ZpWxs6dhLGmSpMT32eyX3Mui5tKf=s1366" style="margin-left: 1em; margin-right: 1em;"><img alt="Put 2 windows together" border="0" data-original-height="748" data-original-width="1366" height="350" src="https://blogger.googleusercontent.com/img/a/AVvXsEjrx0s7f_r-28DrJ4XmeFRTHCtOge0wJ7b0YWqCFu-8-VzkALVEABPcICQk3V9ubrLCo8gKsmiEJSnZdSGGFyN_rtni6Y7tr213P0JVkQJgD2AF5qUY1h-6HNqO3l5FInYE2BS84RxXpUuF5GwHLnnKCulN9ey4ZpWxs6dhLGmSpMT32eyX3Mui5tKf=w640-h350" title="Put 2 windows together" width="640" /></a> </p><ul style="text-align: justify;"><li style="line-height: 1;">Select the e-mails you want to backup by clicking each checkbox or by using the <i>shift </i>key to select a range. Remember that some account can't receive a big amount of e-mails at the same time, you will need to find this number by trying.</li></ul><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEinSJnU7Womvnhn-MmDDa6j9mpHIUpsTcaW0Wek3HX4YLvQtVlj0s-WwxEQGNxmIfZ-c459kXxT4uEAM5tIEBIrvnlPL9t4DqbdCeyGnuY8HEsz4oXTfIQ_QicA91jvCeKSxHxyCxkNQYtT7ZV25CUpncRhb8sK4uwI9YN_NS2ub4c7vX9LZZZYXtT_=s683" style="margin-left: 1em; margin-right: 1em;"><img alt="Select emails to back up" border="0" data-original-height="498" data-original-width="683" height="466" src="https://blogger.googleusercontent.com/img/a/AVvXsEinSJnU7Womvnhn-MmDDa6j9mpHIUpsTcaW0Wek3HX4YLvQtVlj0s-WwxEQGNxmIfZ-c459kXxT4uEAM5tIEBIrvnlPL9t4DqbdCeyGnuY8HEsz4oXTfIQ_QicA91jvCeKSxHxyCxkNQYtT7ZV25CUpncRhb8sK4uwI9YN_NS2ub4c7vX9LZZZYXtT_=w640-h466" title="Select emails to back up" width="640" /></a> </p><ul style="text-align: justify;"><li style="line-height: 1;">Click one of the selected e-mails to drag and drop the selected e-mails to the other window.</li></ul><p style="text-align: center;"></p><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhpWeap5I4n8c92ML-iKYQPxe7s9mtY9I2CBwMLNcq-ybIfGh8lahRYZ1P9EwTkFrgMXqTaZyJaJh5lQIOSw06FF3vAnEcz3NWb_ej7pRogQl8aHMwyAodnKTAvf7GGqKdgbxNWXgOu0tEb_X6QD1EbQ0z6gJPypdN0Uf2VIq-NktyYEHoi3HekeOJq=s883" style="margin-left: 1em; margin-right: 1em;"><img alt="Drag and drop emails" border="0" data-original-height="494" data-original-width="883" height="358" src="https://blogger.googleusercontent.com/img/a/AVvXsEhpWeap5I4n8c92ML-iKYQPxe7s9mtY9I2CBwMLNcq-ybIfGh8lahRYZ1P9EwTkFrgMXqTaZyJaJh5lQIOSw06FF3vAnEcz3NWb_ej7pRogQl8aHMwyAodnKTAvf7GGqKdgbxNWXgOu0tEb_X6QD1EbQ0z6gJPypdN0Uf2VIq-NktyYEHoi3HekeOJq=w640-h358" title="Drag and drop emails" width="640" /></a> </p><ul style="text-align: justify;"><li style="line-height: 1;">Wait for the e-mails to load as attachments.</li></ul><p style="text-align: center;"></p><p style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhFon_ELVD-2QTi-rUBFSzNpfOCRedvy8jZLDAMBSEkWvY7Ti392r-BsAjwcGhVyksa-RWUVXw8pGVUeEfFL-bzfHRfiUFMYUhZOX_8Xl2LiXAgKohvY36c7csK5y3_emIdUKnz0Cd5Nsy_W6VvZXu8GN3C0_E08D_ySGKmAfviw9LUx6r--M8Oxh7i=s683" style="margin-left: 1em; margin-right: 1em;"><img alt="Wait for attachments to load" border="0" data-original-height="453" data-original-width="683" height="424" src="https://blogger.googleusercontent.com/img/a/AVvXsEhFon_ELVD-2QTi-rUBFSzNpfOCRedvy8jZLDAMBSEkWvY7Ti392r-BsAjwcGhVyksa-RWUVXw8pGVUeEfFL-bzfHRfiUFMYUhZOX_8Xl2LiXAgKohvY36c7csK5y3_emIdUKnz0Cd5Nsy_W6VvZXu8GN3C0_E08D_ySGKmAfviw9LUx6r--M8Oxh7i=w640-h424" title="Wait for attachments to load" width="640" /></a> </p><ul style="text-align: justify;"><li style="line-height: 1;">Send that message to the e-mail you want. <br /></li></ul><div style="text-align: justify;"><b>Results:</b> If the size of the e-mail you're sending is too big, you will receive a reply notifying this. Else, you will receive an e-mail in the other account with the messages, you can open the e-mail from there when you want.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><br /></div>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-17147754344552948552020-06-14T20:47:00.004+02:002022-01-23T17:00:24.433+01:00Create Simple Countdown Timer for Debian with Xfce<div style="text-align: justify;">
<b>Case:</b> You use Debian with Xfce Desktop Environment, you need a simple countdown timer and no package convinces you.<br />
<br />
<b>Requisites: </b>Packages <i>libnotify</i> and <i>pulseaudio</i> are installed. <br /></div>
<br />
<b>Steps:</b><br /><ul style="text-align: left;"><li style="line-height: 1;">
Open a text editor and copy this code: <br /><br /><br /><pre style="line-height: 1;">#!/bin/bash</pre><pre style="line-height: 1;"><br />hour=$1</pre><pre style="line-height: 1;">min=$2</pre><pre style="line-height: 1;">sec=$3</pre><pre style="line-height: 1;"><br />while [ $hour -ge 0 ]; do</pre><pre style="line-height: 1;"> while [ $min -ge 0 ]; do</pre><pre style="line-height: 1;"> while [ $sec -ge 0 ]; do</pre><pre style="line-height: 1;"> echo -ne "$hour:$min:$sec\r"</pre><pre style="line-height: 1;"> let "sec=sec-1"</pre><pre style="line-height: 1;"> sleep 1</pre><pre style="line-height: 1;"> done</pre><pre style="line-height: 1;"> sec=59</pre><pre style="line-height: 1;"> let "min=min-1"</pre><pre style="line-height: 1;"> done</pre><pre style="line-height: 1;"> min=59</pre><pre style="line-height: 1;"> let "hour=hour-1"</pre><pre style="line-height: 1;">done</pre><pre style="line-height: 1;"><br />notify-send --urgency CRITICAL "Countdown is over!"</pre><pre style="line-height: 1;">paplay /usr/share/sounds/freedesktop/stereo/alarm-clock-elapsed.oga</pre><br /><br /><br /></li><li>Customize the message by editing <i>"Countdown is over!"<b> </b></i>(don't remove the <i>"</i>) and the sound by changing the audio file path (<i>/usr/share/sounds/freedesktop/stereo/alarm-clock-elapsed.oga</i>).<br /><br /></li><li>Save the file with an easy name, e.g. <i>countdownApp.<br /><br /></i></li><li>You can run the file by opening a terminal, going to the directory file and running <i>./file_name <hours> <minutes> <seconds> </i>:<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEj5t6vOPz2E_mddqiqS33A1s8Irm_vLIPms8gAae1PtRIkp2u6XTx4p2qcuiR4yqy_4ULUVROFJV9ATUhajccooU2v5MQ8PLOaTDbFwhIboIvXcHkDOvE4-yaVbAkrepxcydoJvjnXArAUiXz1Ufj0BKVuWaoT4dd5EQbtExlbyHtzruLd6xq8M_DaH=s801" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Run countdown in terminal" border="0" data-original-height="100" data-original-width="801" height="80" src="https://blogger.googleusercontent.com/img/a/AVvXsEj5t6vOPz2E_mddqiqS33A1s8Irm_vLIPms8gAae1PtRIkp2u6XTx4p2qcuiR4yqy_4ULUVROFJV9ATUhajccooU2v5MQ8PLOaTDbFwhIboIvXcHkDOvE4-yaVbAkrepxcydoJvjnXArAUiXz1Ufj0BKVuWaoT4dd5EQbtExlbyHtzruLd6xq8M_DaH=w640-h80" title="Run countdown in terminal" width="640" /></a></div><br /></li><li>If you want to run it from any directory, put the file in <i>/usr/local/bin </i>and run it without <i>./</i> :<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiLp4J5c7WcqdyuL74BdMf7dCfqOQUnWEhVpBBWQ7tq_jUt17fsPFmbeHWBw6cQT4B2vDbeUaNnHT0MjrnT-qo0IISyuG-f3oDlxou-AhZbLbMhjoGnCkfjdVR2R2plSSYzPT3OOka-XtXRGzDs8B4zSDqlTbutUYyswry41Tx5_57VVGSb-GMFaCER=s822" style="margin-left: 1em; margin-right: 1em;"><img alt="Run countdown from any folder" border="0" data-original-height="117" data-original-width="822" height="92" src="https://blogger.googleusercontent.com/img/a/AVvXsEiLp4J5c7WcqdyuL74BdMf7dCfqOQUnWEhVpBBWQ7tq_jUt17fsPFmbeHWBw6cQT4B2vDbeUaNnHT0MjrnT-qo0IISyuG-f3oDlxou-AhZbLbMhjoGnCkfjdVR2R2plSSYzPT3OOka-XtXRGzDs8B4zSDqlTbutUYyswry41Tx5_57VVGSb-GMFaCER=w640-h92" title="Run countdown from any folder" width="640" /></a> <br /></div></li></ul><div><b>Results:</b> The countdown timer will start showing the time moving:</div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-ew9N_MjvAeI/XuY_aXpAOnI/AAAAAAAACr0/xUKmJ0LTgm0H6gErd9awkf49FqfTMegWQCK4BGAsYHg/s823/Blog3.jpg" style="margin-left: 1em; margin-right: 1em;"> </a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhNyjX5SsElZZ3-dW6_6s2udc7sC6ADVh_FgrbPiZ--6psMMsC755N9t1O8JZyDDs84pYj8UHA4Gfm5vtCWPmUFIXwNg_9F82-INKzh8t-dqz6iSDQwzuxxnI5XQmarmVi4_cU1bed1Mw4Xz0ZA-_YDMVu9iDTF1Z5RA7DqSIuL7vC2-Nd2gaNtqmm6=s823" style="margin-left: 1em; margin-right: 1em;"><img alt="Countdown will start" border="0" data-original-height="119" data-original-width="823" height="92" src="https://blogger.googleusercontent.com/img/a/AVvXsEhNyjX5SsElZZ3-dW6_6s2udc7sC6ADVh_FgrbPiZ--6psMMsC755N9t1O8JZyDDs84pYj8UHA4Gfm5vtCWPmUFIXwNg_9F82-INKzh8t-dqz6iSDQwzuxxnI5XQmarmVi4_cU1bed1Mw4Xz0ZA-_YDMVu9iDTF1Z5RA7DqSIuL7vC2-Nd2gaNtqmm6=w640-h92" title="Countdown will start" width="640" /></a> <br /></div></div><div><br /></div><div>And it will notify you when it's over with a message and a sound:</div><div> </div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgRo9-TP42gXZPilwIDBstnf2QnGpD320em-3oWlNq1tCvnVy8RuQ1trKyS1uWYERuizzeNQzmz_a6z1Haw8qJkiZ_wpHMKEfsbJN3nr5hF1E3qETXH1GBDsX2Pj8K0QbiDgX-ecWUe3TtUlT7jlfSOjP27XGtppNGLgcjaXd4s88Ux0OLWL-cvmj2q=s212" style="margin-left: 1em; margin-right: 1em;"><img alt="Countdown starts" border="0" data-original-height="82" data-original-width="212" src="https://blogger.googleusercontent.com/img/a/AVvXsEgRo9-TP42gXZPilwIDBstnf2QnGpD320em-3oWlNq1tCvnVy8RuQ1trKyS1uWYERuizzeNQzmz_a6z1Haw8qJkiZ_wpHMKEfsbJN3nr5hF1E3qETXH1GBDsX2Pj8K0QbiDgX-ecWUe3TtUlT7jlfSOjP27XGtppNGLgcjaXd4s88Ux0OLWL-cvmj2q=s16000" title="Countdown starts" /></a> <br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div></div>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-56381535718839237062020-05-09T11:30:00.004+02:002022-01-23T17:09:07.181+01:00Use PowerPoint as a Concurrent-Editable Board<div style="text-align: justify;">
<b>Case:</b> You need an online board where anyone can access at the same time and work on it, could be a Kanban board, <a href="https://www.scaledagile.com/" target="_blank">SAFe</a> Program/Team Board, User Story Map, Customer Journey Map and so on. However, you don't want to get an additional tool.<br />
<br />
<b>Requisites:</b> Internet access, <a href="https://www.microsoft.com/en-us/microsoft-365/powerpoint">PowerPoint</a> and <a href="https://www.microsoft.com/en/microsoft-365/onedrive/online-cloud-storage" target="_blank">OneDrive</a> or <a href="https://www.microsoft.com/en-us/microsoft-365/sharepoint/collaboration" target="_blank">SharePoint</a>.<br /></div>
<br />
<b>Steps:</b><br />
<ul><li>Create one slide and change its size according to your needs (Design > Slide Size > Custom Slide Size...):<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhFxJcS2m8qNIgANFvfW1_4EjEdTuSCp4NU0_x6co9nKLKiJYt29kVSM5_yXNVHqBKDzkgXJUsjbUzZ8A7rvE4N7zGydkhiC8ot6VZB2SzIcjGO6hnWx6ViHuEKR-94qlhMNwbdIrbkuCBF7Rk5xTg6pHr_gDyf2NX9nL6Tbssb67BAlGL5-6vbjrMr=s512" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Change slide size" border="0" data-original-height="119" data-original-width="512" height="148" src="https://blogger.googleusercontent.com/img/a/AVvXsEhFxJcS2m8qNIgANFvfW1_4EjEdTuSCp4NU0_x6co9nKLKiJYt29kVSM5_yXNVHqBKDzkgXJUsjbUzZ8A7rvE4N7zGydkhiC8ot6VZB2SzIcjGO6hnWx6ViHuEKR-94qlhMNwbdIrbkuCBF7Rk5xTg6pHr_gDyf2NX9nL6Tbssb67BAlGL5-6vbjrMr=w640-h148" title="Change slide size" width="640" /></a></div></li></ul>
<ul><div class="separator" style="clear: both; text-align: center;">
</div><li>Edit the slide to have what you need before sharing it:</li></ul><div style="text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiSB6SXPpR5BI6ZeqwpTQoYKUKPu5Y8FtzWm-4SGMbnt8S5LMOslIprvQYRQ2hav4g853LJXyM7ehwz66-yNlcJoT04sFnVmmP1yotx7p4TTcdyUdaQp-p0F-nfu33BBTr6RG_zlVVEjmI7nLXlg6NvOUIxNJSwLuPPcke55wCu2q0rgcL5DppaUWea=s512" style="margin-left: 1em; margin-right: 1em;"><img alt="Edit slide to have what you need" border="0" data-original-height="272" data-original-width="512" height="340" src="https://blogger.googleusercontent.com/img/a/AVvXsEiSB6SXPpR5BI6ZeqwpTQoYKUKPu5Y8FtzWm-4SGMbnt8S5LMOslIprvQYRQ2hav4g853LJXyM7ehwz66-yNlcJoT04sFnVmmP1yotx7p4TTcdyUdaQp-p0F-nfu33BBTr6RG_zlVVEjmI7nLXlg6NvOUIxNJSwLuPPcke55wCu2q0rgcL5DppaUWea=w640-h340" title="Edit slide to have what you need" width="640" /></a></div></div><ul><li>Upload the file in OneDrive or SharePoint and share the link.</li><br /><li>Make the contributors access the file by using the app, as the browser version is limited: <br /></li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEg5xBh2ltngOwbGOmRsa8yqtpY6qKinAiN4ALO3OgPtVmMJJYLBMQT6TS_FCDty3VdBD8fh8RWyYDvHPDca3E2ZheW5KaodIPUyME9i94daTxSxuPa77V8NCdrtTgJH5Befo1Ol9jY60iAnFs_GM1ZyZryRuUyL4V-ttMZhNp-LVOLxywnsOvcaM6jm=s512" style="margin-left: 1em; margin-right: 1em;"><img alt="Make users to use the app" border="0" data-original-height="280" data-original-width="512" height="219" src="https://blogger.googleusercontent.com/img/a/AVvXsEg5xBh2ltngOwbGOmRsa8yqtpY6qKinAiN4ALO3OgPtVmMJJYLBMQT6TS_FCDty3VdBD8fh8RWyYDvHPDca3E2ZheW5KaodIPUyME9i94daTxSxuPa77V8NCdrtTgJH5Befo1Ol9jY60iAnFs_GM1ZyZryRuUyL4V-ttMZhNp-LVOLxywnsOvcaM6jm=w400-h219" title="Make users to use the app" width="400" /></a> <br /></div><br /><div><b>Results:</b> Contributors will start working on the file concurrently and they will be able to see each other's modification, for example here the user MR in green is editing also the file:<br /><br /></div><div style="text-align: center;"><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjXfVjd5qJzhTrPUVhQqBq6eD4eGc5Io-uZqxs3YmRHKMsJ_Br_avf5x6SY1MD8Av_xvbEm69NV6zkE6UjwfGgvl8KntZe8xZPOcvX5OTGqjDxWR09lRfA7tEkSxRXSibuiDG7Ym6LiSG1GtlNyC6EjXPCGrBnQysjTc6mChEJaM0fDtgKZBkAxKm3N=s512" style="margin-left: 1em; margin-right: 1em;"><img alt="Contributor will start working in parallel" border="0" data-original-height="310" data-original-width="512" height="388" src="https://blogger.googleusercontent.com/img/a/AVvXsEjXfVjd5qJzhTrPUVhQqBq6eD4eGc5Io-uZqxs3YmRHKMsJ_Br_avf5x6SY1MD8Av_xvbEm69NV6zkE6UjwfGgvl8KntZe8xZPOcvX5OTGqjDxWR09lRfA7tEkSxRXSibuiDG7Ym6LiSG1GtlNyC6EjXPCGrBnQysjTc6mChEJaM0fDtgKZBkAxKm3N=w640-h388" title="Contributor will start working in parallel" width="640" /></a> <br /></div></div><div><br /></div><div><br /></div>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-41675955019470536632020-03-24T18:25:00.006+01:002022-01-23T17:42:18.901+01:00Install TWRP Recovery in Xiaomi Redmi 6A<div style="text-align: justify;">
<b>Case:</b> You try to install TWRP Recovery in your Xiaomi Redmi 6A, but the official process doesn't work.<br />
<br />
<b>Requisites:</b> Xiaomi Redmi 6A phone, USB cable, computer with Windows and <a href="https://www60.zippyshare.com/v/avDsyZOn/file.html">TWRP Cactus Tools installed</a>.</div>
<br />
<a href="https://www.blogger.com/blogger.g?blogID=5739196489377544228" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=5739196489377544228" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><b>Steps:</b><br />
<ul>
<li>Make sure the phone is connected to the computer and in debug mode. </li>
</ul>
<ul><div class="separator" style="clear: both; text-align: center;">
</div>
<li>Open TWRP Cactus Tools:<br /><br /> <a href="https://blogger.googleusercontent.com/img/a/AVvXsEgls-Auw6ytX-HtFpz8DgzrH70JkwHpG9y02aB9MbmcvfTIhSLIUHKs7QdGn3QIfbN97L3AgRAHvtkdWnJdsfmC0gTyxl3l7iNnALOCDNe7Fw0oKHHkTkL4CAFFxaQ6Hug6l5Z8y2GZwVxCW-qL-8y6CPPH8zwDo2de8dU2zuzczoXxMVp7aJ0nZ1a2=s957" style="margin-left: 1em; margin-right: 1em;"><img alt="Open TWRP Cactus tool" border="0" data-original-height="458" data-original-width="957" height="306" src="https://blogger.googleusercontent.com/img/a/AVvXsEgls-Auw6ytX-HtFpz8DgzrH70JkwHpG9y02aB9MbmcvfTIhSLIUHKs7QdGn3QIfbN97L3AgRAHvtkdWnJdsfmC0gTyxl3l7iNnALOCDNe7Fw0oKHHkTkL4CAFFxaQ6Hug6l5Z8y2GZwVxCW-qL-8y6CPPH8zwDo2de8dU2zuzczoXxMVp7aJ0nZ1a2=w640-h306" title="Open TWRP Cactus tool" width="640" /></a></li></ul><ul>
<li>Click 'Flash TWRP' and select the right TWRP (be careful with the Android version):</li>
</ul><p><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhjHACKPP2cMoo2rGz28OWTu0TBuOP3PSY6Zgs7WjDy33GZeQkkGnKdWlvFVk9SDw1yOUxLxQmCOlhz_BqwGBl6hlrGOmw5Mx9DZq2EoHYSCSFwulwLdYvQ4Ft54YdkpvCnjuwB9Cvit1xEpay5PvT8bVFH8gfLiLXGrZbkD1WHd6rO0Gzzi1oVtxBy=s697" style="margin-left: 1em; margin-right: 1em;"><img alt="Click Flash TWRP" border="0" data-original-height="262" data-original-width="697" height="240" src="https://blogger.googleusercontent.com/img/a/AVvXsEhjHACKPP2cMoo2rGz28OWTu0TBuOP3PSY6Zgs7WjDy33GZeQkkGnKdWlvFVk9SDw1yOUxLxQmCOlhz_BqwGBl6hlrGOmw5Mx9DZq2EoHYSCSFwulwLdYvQ4Ft54YdkpvCnjuwB9Cvit1xEpay5PvT8bVFH8gfLiLXGrZbkD1WHd6rO0Gzzi1oVtxBy=w640-h240" title="Click Flash TWRP" width="640" /></a> </p><ul>
</ul>
<ul>
<li>Click 'Start Flash'</li>
</ul><p><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiTol2pf48qfPucK6kL-89Ig2YAFIiNXP4OTvVe7ChHb4VXnhV-xxDhjQ7jLhlfD86z2qhTj0ZGHgB5JT1LyLQyys8T2NHz3Lr7As3k2cGUffaeCZck9pUjX8ugl6ARkuCDfBG8eQi7ecWTbnNqY1jTd3WjtRUNHscXlMGDSVG0L13dBB5a4BWHEHPL=s847" style="margin-left: 1em; margin-right: 1em;"><img alt="Start flash" border="0" data-original-height="284" data-original-width="847" height="214" src="https://blogger.googleusercontent.com/img/a/AVvXsEiTol2pf48qfPucK6kL-89Ig2YAFIiNXP4OTvVe7ChHb4VXnhV-xxDhjQ7jLhlfD86z2qhTj0ZGHgB5JT1LyLQyys8T2NHz3Lr7As3k2cGUffaeCZck9pUjX8ugl6ARkuCDfBG8eQi7ecWTbnNqY1jTd3WjtRUNHscXlMGDSVG0L13dBB5a4BWHEHPL=w640-h214" title="Start flash" width="640" /></a> <br />
<br />
<b>Results:</b> The flash will finish and your phone will have the TWRP recovery.<br />
<br />
<br /></p>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com9tag:blogger.com,1999:blog-5739196489377544228.post-86450785391220290222020-02-16T22:06:00.002+01:002022-01-23T17:52:36.591+01:00Fix unauthorized message with adb devices<div style="text-align: justify;">
<b>Case:</b> You connect your Android phone to your computer, run the command 'adb devices' and your device is unauthorized. Even if you authorized the device.</div><div style="text-align: center;"></div><div style="text-align: center;"></div><div style="text-align: center;"></div><p>
</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjmcnGz9_ND9kj5NoYrFo-QJtAebk0TwlMPR9P8sBk9JRAraA_fAOe6bBmTjNpDmKK1x6WAk4S8gY5GqyXhP--tszVOrz4WFSJMHslahC8URh-CxC-RXwHiWnb2KfHSKDJ7uWLxVvDGy3qOy_SaGfU77Q6ivCdL_GY9APLB6Hh2uVcFHwkacv-ofTJE=s526" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Unauthorized message in adb" border="0" data-original-height="81" data-original-width="526" height="61" src="https://blogger.googleusercontent.com/img/a/AVvXsEjmcnGz9_ND9kj5NoYrFo-QJtAebk0TwlMPR9P8sBk9JRAraA_fAOe6bBmTjNpDmKK1x6WAk4S8gY5GqyXhP--tszVOrz4WFSJMHslahC8URh-CxC-RXwHiWnb2KfHSKDJ7uWLxVvDGy3qOy_SaGfU77Q6ivCdL_GY9APLB6Hh2uVcFHwkacv-ofTJE=w400-h61" title="Unauthorized message in adb" width="400" /></a></div><br /><div style="text-align: justify;">
<b>Requisites:</b> Android phone, USB cable, computer with Windows and adb installed.</div>
<br />
<b>Steps:</b><br />
<ul>
<li>Make sure the phone is not connected to the computer. </li>
</ul>
<ul>
<li>Remove the previous authorizations given into the phone. </li>
</ul>
<div style="text-align: center;">
</div><div style="text-align: center;"></div><div style="text-align: center;"></div><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEg_ngWp8q7N6O5L8cOa000cXEcW91CG5f6ETz8eOUTOhO096-hiHl6xGuNMZ-SCCqeXc351UG1DbaBOpmHXt8dJDA_9SZeH5s96rJLWlwiChuKoIvOJI2jU4e7rFASk0i84xz9mVplekzKbjpy267XvROHY73CzfCdCkm0ZECw3OkBr6zxEb7O2WFBB=s492" style="margin-left: 1em; margin-right: 1em;"><img alt="Remove previous authorizations" border="0" data-original-height="492" data-original-width="327" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEg_ngWp8q7N6O5L8cOa000cXEcW91CG5f6ETz8eOUTOhO096-hiHl6xGuNMZ-SCCqeXc351UG1DbaBOpmHXt8dJDA_9SZeH5s96rJLWlwiChuKoIvOJI2jU4e7rFASk0i84xz9mVplekzKbjpy267XvROHY73CzfCdCkm0ZECw3OkBr6zxEb7O2WFBB=w266-h400" title="Remove previous authorizations" width="266" /></a></div>
<ul>
<li>Kill the adb server.</li>
</ul><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgE2FXI6BF0uSkTmWJk9UOPLuABEXg5aXN-VASxD8P0Aof5t_xRlfmOPyLAJ0jIM2g75UW7573JFP1tnZQuvEUyZDTkI7cr9oxknBwFciOq6t-tA_PqjTvfS-_l1fhYbbTJVZXSFEHgAbiDRzUKOyBP89DaHJ6iOtXE77A7YASkKCXZ3suu0ugDmjrp=s579" style="margin-left: 1em; margin-right: 1em;"><img alt="Kill adb server" border="0" data-original-height="23" data-original-width="579" height="16" src="https://blogger.googleusercontent.com/img/a/AVvXsEgE2FXI6BF0uSkTmWJk9UOPLuABEXg5aXN-VASxD8P0Aof5t_xRlfmOPyLAJ0jIM2g75UW7573JFP1tnZQuvEUyZDTkI7cr9oxknBwFciOq6t-tA_PqjTvfS-_l1fhYbbTJVZXSFEHgAbiDRzUKOyBP89DaHJ6iOtXE77A7YASkKCXZ3suu0ugDmjrp=w400-h16" title="Kill adb server" width="400" /></a> <br /></div>
<ul>
<li>Remove the key files.</li>
</ul><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEim2DsjidtkIEdFBvsx5hn5jy8kHF9zwfKMgqOt3mIRl93ZACeKvltDrZT12S5paldXSbNk3sM3bCPMXu1rVrEmvV5ANW1by4qZkSNpFHsC73QQNUFBEFLZv3eNME4HX877z15gkiHRAQi_M5e9vcPCpjJY-aD0koksQX9OCf96sqx4pOjOuo7WYwlC=s409" style="margin-left: 1em; margin-right: 1em;"><img alt="Remove key files" border="0" data-original-height="178" data-original-width="409" height="174" src="https://blogger.googleusercontent.com/img/a/AVvXsEim2DsjidtkIEdFBvsx5hn5jy8kHF9zwfKMgqOt3mIRl93ZACeKvltDrZT12S5paldXSbNk3sM3bCPMXu1rVrEmvV5ANW1by4qZkSNpFHsC73QQNUFBEFLZv3eNME4HX877z15gkiHRAQi_M5e9vcPCpjJY-aD0koksQX9OCf96sqx4pOjOuo7WYwlC=w400-h174" title="Remove key files" width="400" /></a> <br /></div>
<ul>
<li>Connect the phone to the computer with the USB cable. </li>
</ul>
<ul>
<li>Run the command 'adb devices'. </li>
</ul>
<ul>
<li>In the phone, accept to give the authorization.</li>
</ul>
<br />
<b>Results:</b> When you run the command 'adb devices', it will show your devices with the status 'device' instead of 'unauthorized'.<br />
<br />
Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-87968916628480879062020-01-05T21:33:00.004+01:002022-01-23T20:52:39.151+01:00Customizing Notification for Groups in WhatsApp on Android<div style="text-align: justify;">
<b>Case:</b> I'm in a WhatsApp group and I want this group to play a unique sound so it can be easily identified.<br />
</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<b>Requisites:</b> WhatsApp is installed on an Android smartphone and you have a group to configure.</div>
<div style="text-align: justify;">
<br />
<b>Steps:</b></div>
<div class="separator" style="clear: both; text-align: justify;">
</div>
<ul style="text-align: justify;">
<li>Open the group and click the 3 dots.</li></ul><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiEeOyEdYqXQsE_7dtbAnPeN0YSgyl7sE7e1Fuvypms9cPPBJJvp-5MCVOghes2ojuQ0J1ba1xDC78TF_PbZbLl_-w--ai5fMEzQZ-HVImtDZwwUmx27NX7HJW12FsVDNK9g2nj3g-4Y8TVX3tBMvuTUUA4DMMl7KCNPnE9k0i-_XCBa-C7uhUB6hob=s720" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Click 3 dots in group" border="0" data-original-height="646" data-original-width="720" height="287" src="https://blogger.googleusercontent.com/img/a/AVvXsEiEeOyEdYqXQsE_7dtbAnPeN0YSgyl7sE7e1Fuvypms9cPPBJJvp-5MCVOghes2ojuQ0J1ba1xDC78TF_PbZbLl_-w--ai5fMEzQZ-HVImtDZwwUmx27NX7HJW12FsVDNK9g2nj3g-4Y8TVX3tBMvuTUUA4DMMl7KCNPnE9k0i-_XCBa-C7uhUB6hob=w320-h287" title="Click 3 dots in group" width="320" /></a><br /></div></div>
<ul style="text-align: justify;">
<li>Access to the group information.</li></ul><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjfRXpe0VXtLvP3Ot29ERUNWThWSdnLqkR4Vyoew3Nn3v7wX3aPTBiQVgQQPZmkoLX-nLvglqmF-oZiXUwkMT5xamuff-0i9sPNqup_IAylwJehT-4Xl7rNHKk8y7sLTQk0Mp1_3Pu8gXgVQWj5yzNJP6kD1gEXfMRkL73IaZEfVxK0J5wtHZEy3QXh=s720" style="margin-left: 1em; margin-right: 1em;"><img alt="Access group information" border="0" data-original-height="645" data-original-width="720" height="287" src="https://blogger.googleusercontent.com/img/a/AVvXsEjfRXpe0VXtLvP3Ot29ERUNWThWSdnLqkR4Vyoew3Nn3v7wX3aPTBiQVgQQPZmkoLX-nLvglqmF-oZiXUwkMT5xamuff-0i9sPNqup_IAylwJehT-4Xl7rNHKk8y7sLTQk0Mp1_3Pu8gXgVQWj5yzNJP6kD1gEXfMRkL73IaZEfVxK0J5wtHZEy3QXh=w320-h287" title="Access group information" width="320" /></a> <br /></div>
<ul style="text-align: justify;">
<li>There, go to 'Custom notifications'. <br /></li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhxmLpmmwSYJpf166H3JOqtT8li6Nm1aYf9Qr9OM1HnrUbSGqlgLvPVPEys_8m_tAZwfLNzOAANDApMehCxoliyzu77KguSyfQxNwWnqGPGwbFJevYGkR-vVZoe6Ens_C_A9b08LGbvsfev7MWqph7UFpsSGLaonBEmwHvAsmYJzU3zZvZOYe2Y9ku6=s993" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to Custom notifications" border="0" data-original-height="993" data-original-width="717" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEhxmLpmmwSYJpf166H3JOqtT8li6Nm1aYf9Qr9OM1HnrUbSGqlgLvPVPEys_8m_tAZwfLNzOAANDApMehCxoliyzu77KguSyfQxNwWnqGPGwbFJevYGkR-vVZoe6Ens_C_A9b08LGbvsfev7MWqph7UFpsSGLaonBEmwHvAsmYJzU3zZvZOYe2Y9ku6=w289-h400" title="Go to Custom notifications" width="289" /></a> <br /></div>
<ul style="text-align: justify;">
<li>Now you can activate the custom notification for the group.<a href="https://1.bp.blogspot.com/-NLiSVKU7K8A/XhJEm2QogsI/AAAAAAAACks/70gCyFVu_LkjCSUvyZPx2I_cHu-xAwghgCLcBGAsYHQ/s1600/Foto4.png" style="margin-left: 1em; margin-right: 1em;"></a></li></ul><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjPnbD29XnjNAdUmnOoYO_CkBtatC6gGEj0hh_nK9obqONJ34puDyrUKOkJCLcGJ6VeLRf42jnVF4jLAh7CZ1GqnlXHLCA0z9I20RT021iExoxgh6z1Etz8tlG0a17UiJmQ4fPBkipZSqn8nn2eGldFU8qYIeAlpnohF2hUCR-vtt-WkK1as-27zG4A=s1440" style="margin-left: 1em; margin-right: 1em;"><img alt="Activate custom notification" border="0" data-original-height="1440" data-original-width="720" height="640" src="https://blogger.googleusercontent.com/img/a/AVvXsEjPnbD29XnjNAdUmnOoYO_CkBtatC6gGEj0hh_nK9obqONJ34puDyrUKOkJCLcGJ6VeLRf42jnVF4jLAh7CZ1GqnlXHLCA0z9I20RT021iExoxgh6z1Etz8tlG0a17UiJmQ4fPBkipZSqn8nn2eGldFU8qYIeAlpnohF2hUCR-vtt-WkK1as-27zG4A=w320-h640" title="Activate custom notification" width="320" /></a> <br /></div>
<br />
<br />
Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-70807239080796963642019-08-25T21:27:00.003+02:002022-02-27T17:06:37.108+01:00Recording the Screen/Window and Audio of Your Computer<div style="text-align: justify;">
<b>Case:</b> I want to record the screen (or window) and audio (coming from the microphone and the speakers) of my computer in a video file.<br />
</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<b>Requisites:</b> <a href="https://obsproject.com/" target="_blank">Open Broadcaster Software</a> (OBS) is installed.</div>
<div style="text-align: justify;">
<br />
<b>Steps:</b></div>
<ul style="text-align: justify;">
<li>Open OBS.</li>
</ul>
<ul style="text-align: justify;">
<li>Go to 'Settings'. <br /></li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgojVxijRRzPlTZXe5_WPDMz5tTgslfZ8zEHbYHKMPJiILCC5aq0EGGsD5j_RbPQE7t9r6GO7aRU9vn9Vqch-gpuAV9fgKQI4YEWkyLN2stad2nH4Slhanp-noWw80MwulaOVc9_w4v2Y51m6nY6RciXIakjAttF7bHM93NFj75kzFsPlK7HYsf64ZS=s710" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to settings" border="0" data-original-height="239" data-original-width="710" height="135" src="https://blogger.googleusercontent.com/img/a/AVvXsEgojVxijRRzPlTZXe5_WPDMz5tTgslfZ8zEHbYHKMPJiILCC5aq0EGGsD5j_RbPQE7t9r6GO7aRU9vn9Vqch-gpuAV9fgKQI4YEWkyLN2stad2nH4Slhanp-noWw80MwulaOVc9_w4v2Y51m6nY6RciXIakjAttF7bHM93NFj75kzFsPlK7HYsf64ZS=w400-h135" title="Go to settings" width="400" /></a> <br /></div>
<ul style="text-align: justify;">
<li>Set the 'Recording Path' for the recording and the format to use.</li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgDuKE51Gf5WTMsz2L9G1P9-KENwasVkJ3ip4OD1cO-xoIwEcGPi8Uixg9i_2uYO5jH2lbBo7Ukzh0YXYeCSng0Tha4p0BhQRDf-nOXyMaUbZieNDuUOS80sBoXW7EcUy6yL3uZkTf15WbedwPDZ5rj6aK9bAGvz_AdHnPWTMFIkD7ybWIA8L6Qf-NY=s1012" style="margin-left: 1em; margin-right: 1em;"><img alt="Set recording path" border="0" data-original-height="553" data-original-width="1012" height="350" src="https://blogger.googleusercontent.com/img/a/AVvXsEgDuKE51Gf5WTMsz2L9G1P9-KENwasVkJ3ip4OD1cO-xoIwEcGPi8Uixg9i_2uYO5jH2lbBo7Ukzh0YXYeCSng0Tha4p0BhQRDf-nOXyMaUbZieNDuUOS80sBoXW7EcUy6yL3uZkTf15WbedwPDZ5rj6aK9bAGvz_AdHnPWTMFIkD7ybWIA8L6Qf-NY=w640-h350" title="Set recording path" width="640" /></a> <br /></div>
<ul style="text-align: justify;">
</ul>
<ul style="text-align: justify;">
<li>Set the video resolution, the base and output resolution must be the same, play with these values if you see that OBS is recording one part of the expected output.</li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgZv1f13pv-N8WA_JTZDl62QLC7KoVv77jJkjwNlflm3HCtnb0NNIMf0axlop3HM-P3hfQN3mg9VV61p_u51LDmCfeMHiJoOhUSdry2IyuMoayAU7fi7vX9ps5kyDFkVPpNX-EY-bmohgRHxiwedqpP5Yy-MQdyvJQXhtpUYK8jSvq1d_78GF3-2jCo=s1017" style="margin-left: 1em; margin-right: 1em;"><img alt="Set video resolution" border="0" data-original-height="360" data-original-width="1017" height="226" src="https://blogger.googleusercontent.com/img/a/AVvXsEgZv1f13pv-N8WA_JTZDl62QLC7KoVv77jJkjwNlflm3HCtnb0NNIMf0axlop3HM-P3hfQN3mg9VV61p_u51LDmCfeMHiJoOhUSdry2IyuMoayAU7fi7vX9ps5kyDFkVPpNX-EY-bmohgRHxiwedqpP5Yy-MQdyvJQXhtpUYK8jSvq1d_78GF3-2jCo=w640-h226" title="Set video resolution" width="640" /></a> <br /></div>
<ul style="text-align: justify;">
<li>Add the video source to record (+), use 'Display Capture' if you want to record the total screen or 'Window Capture' if you want to record only a specific application window. <br /></li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiGuqfdZBVgSfSh4cqOBYNWp1lCjbfJTKvG-Dt6X2klof20jQ8noB6j2OIw2No23XS2o3jXC_Rl8D9c2bu8JSbh3e-jRTkQ-IhpNlOlTno9SIgppxgAnuonHYRpBRkGAESTB_3u-s8Oxg3qcoriWSDxHNiAiAqzRIDclZYhisUAT_iXvb0JolKD7JeQ=s446" style="margin-left: 1em; margin-right: 1em;"><img alt="Select window capture" border="0" data-original-height="446" data-original-width="328" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEiGuqfdZBVgSfSh4cqOBYNWp1lCjbfJTKvG-Dt6X2klof20jQ8noB6j2OIw2No23XS2o3jXC_Rl8D9c2bu8JSbh3e-jRTkQ-IhpNlOlTno9SIgppxgAnuonHYRpBRkGAESTB_3u-s8Oxg3qcoriWSDxHNiAiAqzRIDclZYhisUAT_iXvb0JolKD7JeQ=w294-h400" title="Select window capture" width="294" /></a> <br /></div>
<ul style="text-align: justify;">
<li>Create a new source, use the name you want. <br /></li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgK0Zj4sH5Mpshs38GPrhPNWFsyVQbx7tW0kgNir8pFEX33c56RBxGTmnUn1A2LIrod3ypTO2NeYvTKocs4Rc0J2s0Pn6fT8PvZfLKLt4qRfooLRfAunJJapXhDLejoISmKsj9cJ-u9yoh2JyL2JXXcvxkxHB-x8WKxIHVipIKQNF4XO1r3bo9fSJzU=s414" style="margin-left: 1em; margin-right: 1em;"><img alt="Create new source" border="0" data-original-height="385" data-original-width="414" height="373" src="https://blogger.googleusercontent.com/img/a/AVvXsEgK0Zj4sH5Mpshs38GPrhPNWFsyVQbx7tW0kgNir8pFEX33c56RBxGTmnUn1A2LIrod3ypTO2NeYvTKocs4Rc0J2s0Pn6fT8PvZfLKLt4qRfooLRfAunJJapXhDLejoISmKsj9cJ-u9yoh2JyL2JXXcvxkxHB-x8WKxIHVipIKQNF4XO1r3bo9fSJzU=w400-h373" title="Create new source" width="400" /></a> <br /></div>
<ul style="text-align: justify;">
<li>Select the specific window to record.</li>
</ul><p style="text-align: center;"> <a href="https://blogger.googleusercontent.com/img/a/AVvXsEilOFAd5jJzGOQzSv3lAouysBTlWtFBrbayWHA2CgrRVeYlhjjqPyg8j5VR2YP9zJq4AN639dkARsxMglScUGFU8aXC0D9osiU3zDOm9cxI1sEi_kPkJzJ6NDbptUDktuKT-Mm_mibb-3jok_FxW8mI1E5GLQDCBDliQvKr6O7xvydLJ1a1CDUiujZe=s754" style="margin-left: 1em; margin-right: 1em;"><img alt="Select window" border="0" data-original-height="243" data-original-width="754" height="206" src="https://blogger.googleusercontent.com/img/a/AVvXsEilOFAd5jJzGOQzSv3lAouysBTlWtFBrbayWHA2CgrRVeYlhjjqPyg8j5VR2YP9zJq4AN639dkARsxMglScUGFU8aXC0D9osiU3zDOm9cxI1sEi_kPkJzJ6NDbptUDktuKT-Mm_mibb-3jok_FxW8mI1E5GLQDCBDliQvKr6O7xvydLJ1a1CDUiujZe=w640-h206" title="Select window" width="640" /></a> </p><ul style="text-align: justify;">
</ul>
<ul style="text-align: justify;">
<li>Validate in the preview if what you see is what you expect.</li>
</ul>
<div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgshdigTZjsoLLZFGgbpXoME8py5QVWZknKDehr5I3nJWT2FbevybcWnuevO-CM0cIma1x4RddBZYu9NXwGTC2bvfyBKOEUxGRoRNpqc2eEiTdKJqAwmftpyWyM2CtFS-e-RRhEezX9RZ-_r0EVSrIqqcPDyRrhqXhQ_lhBw5tWXv0Ml_dzZWYggvm7=s1600" style="margin-left: 1em; margin-right: 1em;"><img alt="Validate the preview" border="0" data-original-height="868" data-original-width="1600" height="348" src="https://blogger.googleusercontent.com/img/a/AVvXsEgshdigTZjsoLLZFGgbpXoME8py5QVWZknKDehr5I3nJWT2FbevybcWnuevO-CM0cIma1x4RddBZYu9NXwGTC2bvfyBKOEUxGRoRNpqc2eEiTdKJqAwmftpyWyM2CtFS-e-RRhEezX9RZ-_r0EVSrIqqcPDyRrhqXhQ_lhBw5tWXv0Ml_dzZWYggvm7=w640-h348" title="Validate the preview" width="640" /></a></div></div>
<ul style="text-align: justify;">
<li>Start the recording.</li></ul><ul style="text-align: justify;">
<li>Stop the recording when you think is the right time.</li>
</ul>
<div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/a/AVvXsEh6mu6NjEZEasBzqBQfG2kKC8hWYwVVBYPmrRIoYTAzynhdjjlXxTfTGE9GA41RcMdpwTDtJa7w7SSQmzPQIrgiCP-2DWwrRbQBrz0Y-5nYJM6zzI0iHWCgiNrmyvIO94hjaVAxYpL41j3Cq8pKLOqk2DuyruH5IYjEYHcgngunQmCwBNP29vMe953h=s680" style="margin-left: 1em; margin-right: 1em;"><img alt="Start the recording" border="0" data-original-height="177" data-original-width="680" height="104" src="https://blogger.googleusercontent.com/img/a/AVvXsEh6mu6NjEZEasBzqBQfG2kKC8hWYwVVBYPmrRIoYTAzynhdjjlXxTfTGE9GA41RcMdpwTDtJa7w7SSQmzPQIrgiCP-2DWwrRbQBrz0Y-5nYJM6zzI0iHWCgiNrmyvIO94hjaVAxYpL41j3Cq8pKLOqk2DuyruH5IYjEYHcgngunQmCwBNP29vMe953h=w400-h104" title="Start the recording" width="400" /></a></div>
<br />
<ul style="text-align: justify;">
<li>Go to the output path and you will have the recording ready.<br /><br /><div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEj7IifpDDt3onKjmQUpwPfu48oO6NGprK4rwWURArT8e2lAdW2BAoyb9qYoEhytzmqz83Cw1ZQKrS4wIyd-yuDlNfzNkL-75x24iBlOZNAv1HhyNGSi2OUGBLW_0lWRUqj4wY1rgCFsI6_G2P6bs1SciO5XKDUHAeN3X9CCcqoEYVMfNavXdXdar3BJ=s429" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to the path" border="0" data-original-height="252" data-original-width="429" height="235" src="https://blogger.googleusercontent.com/img/a/AVvXsEj7IifpDDt3onKjmQUpwPfu48oO6NGprK4rwWURArT8e2lAdW2BAoyb9qYoEhytzmqz83Cw1ZQKrS4wIyd-yuDlNfzNkL-75x24iBlOZNAv1HhyNGSi2OUGBLW_0lWRUqj4wY1rgCFsI6_G2P6bs1SciO5XKDUHAeN3X9CCcqoEYVMfNavXdXdar3BJ=w400-h235" title="Go to the path" width="400" /></a><br /></div> <div style="text-align: center;"><br /></div></li></ul><ul style="text-align: justify;">
</ul>
<br />Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-50229499098862852612019-06-02T13:51:00.002+02:002022-02-27T17:19:24.789+01:00Notifying When Battery is Full in Linux<br />
<div style="text-align: justify;">
<b>Case:</b> I want to be notified by a sounding popup when the battery of my laptop is fully charged. I'm using <a href="https://www.debian.org/" target="_blank">Debian Linux</a> and <a href="https://www.gnome.org/gnome-3/" target="_blank">Gnome 3</a>.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b>Requisites:</b> The following applications are installed: sh, upower, paplay, notify-send.</div>
<br />
<b>Steps:</b><br />
<br />
<ul>
<li>Open a text editor and put this code (adapted from <a href="https://unix.stackexchange.com/questions/109256/battery-full-notification" target="_blank">here</a>):</li>
</ul>
<pre style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-family: "arial"; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; overflow-wrap: normal; word-wrap: normal;"> #!/usr/bin/env bash
while true
do
export DISPLAY=:0.0
battery_percent=$(upower -i /org/freedesktop/UPower/devices/battery_BAT0 | grep -P -o 'percentage: [0-9]+(?=%)' | grep -P -o [0-9]*)
if on_ac_power; then
echo $on_ac_power
if [ "$battery_percent" -gt 92 ]; then
paplay /usr/share/sounds/freedesktop/stereo/suspend-error.oga
notify-send --urgency CRITICAL "Battery full" "Level: ${battery_percent}% "
fi
fi
sleep 60 #
done
</code></pre>
<ul>
<li style="text-align: justify;">Save the file with .sh extension in the user's home directory, choice an understandable name, for example:<b> </b>/home/ronald/BatteryCharged.sh</li>
</ul>
<div style="text-align: justify;">
</div>
<ul style="text-align: justify;">
</ul>
<ul>
<li style="text-align: justify;">Edit the file named <i>.profile</i> of the user's home directory<b>, </b>add at the bottom of the file the line below and save it:<b> </b></li>
</ul>
<ul>
</ul>
<pre style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 1px dashed rgb(204, 204, 204); color: black; font-family: "arial"; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; overflow-wrap: normal; word-wrap: normal;"> add sh /home/ronald/BatteryCharged.sh &
</code></pre>
<ul>
<li>Reboot the laptop and login.</li>
</ul>
<br />
<ul>
</ul>
<div style="text-align: justify;">
<b>Results: </b>When the battery percentage reaches higher than 92% you will see a popup in the screen and a sound will rise, this will happen each minute until you unplug the power cable.</div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEg4Sp87PYZDGUClWSFJC5KaURG2yHyC9bTlkLbGn1FvOiow6JYznROHuv0L61u5YO-cLAtom22txb4x4s6zuf_8lua5hUaat43jXHg-PlKc1aQoN4Qc-spm-PU9cAyUVFdFEP6CLZVCYWl6SEzRczHlBOj2AAVl6Px9VD3ZH_x8__56KMnZuDZMqqSG=s414" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Battery popup in the screen" border="0" data-original-height="86" data-original-width="414" height="83" src="https://blogger.googleusercontent.com/img/a/AVvXsEg4Sp87PYZDGUClWSFJC5KaURG2yHyC9bTlkLbGn1FvOiow6JYznROHuv0L61u5YO-cLAtom22txb4x4s6zuf_8lua5hUaat43jXHg-PlKc1aQoN4Qc-spm-PU9cAyUVFdFEP6CLZVCYWl6SEzRczHlBOj2AAVl6Px9VD3ZH_x8__56KMnZuDZMqqSG=w400-h83" title="Battery popup in the screen" width="400" /></a></div><br /> </div>
<br />
<b></b>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-44801523794879428342019-01-06T21:52:00.001+01:002022-02-27T17:38:58.210+01:00Using Gestures to Open Apps in Android<div style="text-align: justify;">
You need to use a calculator, so you take your <a href="https://www.android.com/" target="_blank">Android</a> phone and tap on the calculator icon if you have it in the first screen, or you swipe between screens to find and tap the calculator icon.</div>
<br />
<div style="text-align: justify;">
But, if you don't have the calculator in the screen, you tap on the app menu and then you have to look for the calculator (scrolling all the screens needed). On the other hand, you can take your phone tap on a bubble to open a canvas and draw a gesture there to open the calculator, this being possible in any screen/app of your phone.</div>
<br />
<div style="text-align: justify;">
To have the last feature described you can use <a href="https://play.google.com/store/apps/details?id=com.gesture.action&hl=en" target="_blank">Gesture Magic</a>, after install it you should enable 'Gesture Service' in 'Settings'.</div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEhll06y-wyzV1lUTjU_rAqD07EJ-jdPYPttHsyHTfUhuCcIvaRhb8O7ERgz_xT_mIief3L-w_EhQJTJ_aqTXuw36ijKPCNlt67QRhFJ63npuphRjIpyzDK5jC_wvTP0ndWfBnOoW3ngAc9Tis0FaeiVNHqg0gZnjoQ4usTe055KKAv-5A__WIIXZRRC=s1440" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to settings" border="0" data-original-height="1440" data-original-width="720" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEhll06y-wyzV1lUTjU_rAqD07EJ-jdPYPttHsyHTfUhuCcIvaRhb8O7ERgz_xT_mIief3L-w_EhQJTJ_aqTXuw36ijKPCNlt67QRhFJ63npuphRjIpyzDK5jC_wvTP0ndWfBnOoW3ngAc9Tis0FaeiVNHqg0gZnjoQ4usTe055KKAv-5A__WIIXZRRC=w200-h400" title="Go to settings" width="200" /></a> <br /></div></div>
<br />
Then you should go to 'Gesture Magic' option. <br /><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiVc1-rfVIUDzlbD642Do7xED3rC62dgUesEkVIv4w453josAo_3_RPoyo9Sne-ND4nK2vDy46sizym8t6PDGsxhk95aWH6xHfpalx5Iqmm64sm0dPN7zM_Qcou-axTUIhY0U_cC4xkxdbYTHj7vw3EG6ahYqoaSNLGz2F_HgBN1mYi4Tpr3XVasq3K=s1440" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to Gesture Magic option" border="0" data-original-height="1440" data-original-width="720" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEiVc1-rfVIUDzlbD642Do7xED3rC62dgUesEkVIv4w453josAo_3_RPoyo9Sne-ND4nK2vDy46sizym8t6PDGsxhk95aWH6xHfpalx5Iqmm64sm0dPN7zM_Qcou-axTUIhY0U_cC4xkxdbYTHj7vw3EG6ahYqoaSNLGz2F_HgBN1mYi4Tpr3XVasq3K=w200-h400" title="Go to Gesture Magic option" width="200" /></a></div></div>
<br />
Tap on '+' button in the inferior corner. <br />
<div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgRe_vMEicTd-bHfqReopNufTU4f6WgpzxWWMuEEyF8ABSWHK4dHnAq4WyLzpgl3hPszjSPa1Oj9Q9SquZClauaizMivmdlL9sCts65BMovICM2u21J_QmZNJGpTTF0NPJOYPOaYvsOWF2uX0kUPNyPJcZtZ0SPNh2CaWZ5BrZBJ0YVdIMRZBBetqXN=s1440" style="margin-left: 1em; margin-right: 1em;"><img alt="Click on +" border="0" data-original-height="1440" data-original-width="720" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEgRe_vMEicTd-bHfqReopNufTU4f6WgpzxWWMuEEyF8ABSWHK4dHnAq4WyLzpgl3hPszjSPa1Oj9Q9SquZClauaizMivmdlL9sCts65BMovICM2u21J_QmZNJGpTTF0NPJOYPOaYvsOWF2uX0kUPNyPJcZtZ0SPNh2CaWZ5BrZBJ0YVdIMRZBBetqXN=w200-h400" title="Click on +" width="200" /></a></div><br /></div> Select the action, in this case 'Open Application'. <br /><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgk8ihmT-DXBuUttQiyAd6LOVyDPdNH3y3bmcVj46EbjPcYZr4vbahd3K5_wCtj1vymAtedgtruPNclptRbllFHdBZvOEH9O23d3DMyKQDYy_PchXCUDu2Y6_ILmdKpIy1cuPvzogzZV-xA4nGhUV6a7HD2854wQwA6S9KYeYXzLupKwdk9sI9pYiUi=s1440" style="margin-left: 1em; margin-right: 1em;"><img alt="Open application" border="0" data-original-height="1440" data-original-width="720" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEgk8ihmT-DXBuUttQiyAd6LOVyDPdNH3y3bmcVj46EbjPcYZr4vbahd3K5_wCtj1vymAtedgtruPNclptRbllFHdBZvOEH9O23d3DMyKQDYy_PchXCUDu2Y6_ILmdKpIy1cuPvzogzZV-xA4nGhUV6a7HD2854wQwA6S9KYeYXzLupKwdk9sI9pYiUi=w200-h400" title="Open application" width="200" /></a> <br /></div></div>
<br />
Select the app to be open by a gesture, in this case <a href="https://play.google.com/store/apps/details?id=cz.hipercalc" target="_blank">HIPER Scientific Calculator</a>. <br /><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEh6lGPLZAhZBAJaGyaVpfTIojCfV-59C7c1Nhj45ghfGPfgpDy5L_DMLEs8jjZCBC0sFOTCadnjxHbMQlFg32Cg1gwQubZJD03W0RhVzUMwsxfHA3YwI4IT2PUy2gCGzDIzuhb53A-xjAoJYpg9D7UF1FN0Geyf1Ug68UflUfMejq90USN1RlUlE9po=s1440" style="margin-left: 1em; margin-right: 1em;"><img alt="Select the app to launch" border="0" data-original-height="1440" data-original-width="720" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEh6lGPLZAhZBAJaGyaVpfTIojCfV-59C7c1Nhj45ghfGPfgpDy5L_DMLEs8jjZCBC0sFOTCadnjxHbMQlFg32Cg1gwQubZJD03W0RhVzUMwsxfHA3YwI4IT2PUy2gCGzDIzuhb53A-xjAoJYpg9D7UF1FN0Geyf1Ug68UflUfMejq90USN1RlUlE9po=w200-h400" title="Select the app to launch" width="200" /></a> <br /></div></div>
<br />
Draw the gesture you want 3 times and save it. <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEild4A0AKkik3zqpjS6OFGRbzBHuv2q0jE-AoJ762DtDaHS31iMl7g0xGTqZ50WqzZFrNsgygMYMM25Bmt9TKSB4k5mT6aPOIM0qVCA6Khep4yerir9fMTYsJlSUMaHHOyqPZw_gre0AoMDb-1ecQoEdK1g5pB8Jpq_YSnLCjPgqqeGrU-ZfW5bvEwA=s1440" style="margin-left: 1em; margin-right: 1em;"><img alt="Draw the gesture" border="0" data-original-height="1440" data-original-width="720" height="400" src="https://blogger.googleusercontent.com/img/a/AVvXsEild4A0AKkik3zqpjS6OFGRbzBHuv2q0jE-AoJ762DtDaHS31iMl7g0xGTqZ50WqzZFrNsgygMYMM25Bmt9TKSB4k5mT6aPOIM0qVCA6Khep4yerir9fMTYsJlSUMaHHOyqPZw_gre0AoMDb-1ecQoEdK1g5pB8Jpq_YSnLCjPgqqeGrU-ZfW5bvEwA=w200-h400" title="Draw the gesture" width="200" /></a> <br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
Then, you will be able to move between apps easily by tapping in the bubble, for example going to a calculator and then to a camera.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.blogger.com/video.g?token=AD6v5dwJWmRIVFX3bMO6YRU2zpqdecCDvoGq-1qPhL4uZo4o20Zjy5d19je4i9f7PDjK3n6aSqtEiLc6E0T3bmEsfA' class='b-hbp-video b-uploaded' frameborder='0'></iframe></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
This app can help you to launch not only apps but also call, SMS and more.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br />Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-54303830462437265942018-10-28T19:05:00.002+01:002022-04-04T21:47:34.935+02:00Using Styles in Word<div style="text-align: justify;">
If you have to change the style of a <a href="https://products.office.com/en/word">Word</a> document (like changing the color of the headings), you can do it manually by editing each text or you can edit the style only once.</div><div style="text-align: justify;"> </div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
For this, the recommendation is to set a style for the headings you work with, highlight the heading and go to "Styles" and select the one you want. Do this for all your headings.</div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhioODdUyeu4K4t9GS3nPpNVptzBP9Q2fUgWEfRbWgrAEMF3wfBGwCimvoyRJp_YGU9ayjjPi4EuoOQGkwBCw5ecRQ6MdKl99KA4KmIit5jE_ieolo0R5pivc8wfVYmoaXFq5ZfqFjwbllXlg0HolAYvSZbPtnfJMMJZ0m48JDSlfaqzebc_P2DYxPZ/s1149/UsingStylesWord1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to Styles" border="0" data-original-height="718" data-original-width="1149" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhioODdUyeu4K4t9GS3nPpNVptzBP9Q2fUgWEfRbWgrAEMF3wfBGwCimvoyRJp_YGU9ayjjPi4EuoOQGkwBCw5ecRQ6MdKl99KA4KmIit5jE_ieolo0R5pivc8wfVYmoaXFq5ZfqFjwbllXlg0HolAYvSZbPtnfJMMJZ0m48JDSlfaqzebc_P2DYxPZ/w640-h400/UsingStylesWord1.webp" title="Go to Styles" width="640" /></a><br /></div><br /></div>
<div style="text-align: justify;">
Later, if you want to customize the style (like changing color) you can right-click on the style you are using and select "Modify...".<br /></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwI-9UAWNR_JHKxQUAlVVBxp7IioqjoxX1bGWZxh_9xN0cJVyElXJiqWti34Iz6wCanq3Tauaq7BNBiUZDFwoRC7i_KrRGHrD5GjTa-1djkYenrm9ek8xpvD_AJ1H0yzBKnUo0c_9hVmd1X7aYPAyfBch9xKfhSjWOTzfmFYesN8cwWhixMj-GoJWG/s556/UsingStylesWord2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Modify style" border="0" data-original-height="283" data-original-width="556" height="326" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwI-9UAWNR_JHKxQUAlVVBxp7IioqjoxX1bGWZxh_9xN0cJVyElXJiqWti34Iz6wCanq3Tauaq7BNBiUZDFwoRC7i_KrRGHrD5GjTa-1djkYenrm9ek8xpvD_AJ1H0yzBKnUo0c_9hVmd1X7aYPAyfBch9xKfhSjWOTzfmFYesN8cwWhixMj-GoJWG/w640-h326/UsingStylesWord2.webp" title="Modify style" width="640" /></a><br /></div></div><div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">In the new window edit the color for this style or other properties.<br />
</div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8wxDHnAu_uvcWcFXLqG6t0EfEyTzSBe4vsZoaA2KRPk44fquA8qUrLeLcRhnwGRwpaAAN7FMnW6XFMdsyiX7w7_nbSr40Jl-yKHZmv9UIoAR4Y9XZG8UW7c7zgaWX3hUUN80HtPWotOefW6q5z3mZgpkQle1dVg8OVwiXYbs0woNiqjqbmYrwjkls/s750/UsingStylesWord3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Format the style" border="0" data-original-height="599" data-original-width="750" height="512" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8wxDHnAu_uvcWcFXLqG6t0EfEyTzSBe4vsZoaA2KRPk44fquA8qUrLeLcRhnwGRwpaAAN7FMnW6XFMdsyiX7w7_nbSr40Jl-yKHZmv9UIoAR4Y9XZG8UW7c7zgaWX3hUUN80HtPWotOefW6q5z3mZgpkQle1dVg8OVwiXYbs0woNiqjqbmYrwjkls/w640-h512/UsingStylesWord3.webp" title="Format the style" width="640" /></a><br /></div></div><div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
Once you accept the edition, this will apply to the headings with the same style.</div><div class="separator" style="clear: both; text-align: center;"> <br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhluSLMiBQLGZZltlyQpxxa6HxAFUDIZG2wPEg6O5GdXlpbzX6X2ECB1ldyJBEqoR8yXnCBAqNadCwmeIevJ6DMEnt14Nw-K69NrrSeRqWnPrZX8GIVjwOLG07AyMLiIKHXRLecWutz8HAF6xtRhJwirB8v9YitAhaXHgGRaL5zidEfJAeFYJoOKvgL/s898/UsingStylesWord4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Document with new style" border="0" data-original-height="457" data-original-width="898" height="326" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhluSLMiBQLGZZltlyQpxxa6HxAFUDIZG2wPEg6O5GdXlpbzX6X2ECB1ldyJBEqoR8yXnCBAqNadCwmeIevJ6DMEnt14Nw-K69NrrSeRqWnPrZX8GIVjwOLG07AyMLiIKHXRLecWutz8HAF6xtRhJwirB8v9YitAhaXHgGRaL5zidEfJAeFYJoOKvgL/w640-h326/UsingStylesWord4.webp" title="Document with new style" width="640" /></a><br /></div>
<br />
<div style="text-align: justify;">
You will be able to change the style of your document easily by editing the style and no each text. </div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-18091119555606332482018-09-29T19:48:00.001+02:002022-04-04T21:34:33.971+02:00Assigning Colors for Events in Outlook Calendar<div style="text-align: justify;">
When you have many events in your <a href="https://products.office.com/en/outlook/email-and-calendar-software-microsoft-outlook">Outlook</a> calendar, it's useful to highlight them in different colors according to their categories.</div><div class="separator" style="clear: both; text-align: center;"> <br /></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8AQ5BniQ9FWNeHMM-P-eDa_8p0CqDctNUXMWn4fCula0VWb9DyBzu9psqpJKVxZ_JPVjriqjEe4TpZWrM1garcK-Nryrl-m1ifw3HNWmddg9GWAsoSF9PbdNMRZLxkBiAcFHkTdwiNkCDGPINycdHiiw-Y1Y9C9NVZyA3CLkJF8LDMS6gkHLyDjoM/s922/AssignColorsCalendarOutlook1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Highlight events by color in Outlook" border="0" data-original-height="554" data-original-width="922" height="384" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8AQ5BniQ9FWNeHMM-P-eDa_8p0CqDctNUXMWn4fCula0VWb9DyBzu9psqpJKVxZ_JPVjriqjEe4TpZWrM1garcK-Nryrl-m1ifw3HNWmddg9GWAsoSF9PbdNMRZLxkBiAcFHkTdwiNkCDGPINycdHiiw-Y1Y9C9NVZyA3CLkJF8LDMS6gkHLyDjoM/w640-h384/AssignColorsCalendarOutlook1.webp" title="Highlight events by color in Outlook" width="640" /></a><br /></div></div><div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
It's possible to do this manually for each item, but you can set Outlook to do this automatically by right-clicking on an empty slot on the calendar and click on 'View Settings...'.</div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiP_rKISg9dwTeSOBHtEVin7egm5rznnIormiKj26CRIYFcPbTOn6Ew-pFE40C6-VjsdeNvluzrhZq6NQB9pK-lDFzfZYd_JS7bgu4dNjXPCZrcoAAEJEvVj3W4am2G0pPhUtxvbIwcue3PKdMQBKwLYGFIFjdBZwYbbsif52Vv2lMItKJ8LXDkCB5R/s768/AssignColorsCalendarOutlook2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="View calendar settings in Outlook" border="0" data-original-height="574" data-original-width="768" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiP_rKISg9dwTeSOBHtEVin7egm5rznnIormiKj26CRIYFcPbTOn6Ew-pFE40C6-VjsdeNvluzrhZq6NQB9pK-lDFzfZYd_JS7bgu4dNjXPCZrcoAAEJEvVj3W4am2G0pPhUtxvbIwcue3PKdMQBKwLYGFIFjdBZwYbbsif52Vv2lMItKJ8LXDkCB5R/w640-h478/AssignColorsCalendarOutlook2.webp" title="View calendar settings in Outlook" width="640" /></a><br /></div><br /></div>
In the new windows that appears, click on 'Conditional Formatting...'.<div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5GtSOG--acuSpflRUhvVuwH22nItfMlcXzawJx_ty_x_tenhTbsO097-6bLHDd0SOJ3oLSnhPEs0Bma5p7L1v-DW1vKreaA4LA8ede9UmBeTRFYIuACEXWWtYJNu_cCurotOUXRrcjF-nffe1JjbkpJlYaufhfw-MJXWAmu5ejnFd90SwlR-GOEAx/s548/AssignColorsCalendarOutlook3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Conditioning formatting in calendar" border="0" data-original-height="415" data-original-width="548" height="303" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5GtSOG--acuSpflRUhvVuwH22nItfMlcXzawJx_ty_x_tenhTbsO097-6bLHDd0SOJ3oLSnhPEs0Bma5p7L1v-DW1vKreaA4LA8ede9UmBeTRFYIuACEXWWtYJNu_cCurotOUXRrcjF-nffe1JjbkpJlYaufhfw-MJXWAmu5ejnFd90SwlR-GOEAx/w400-h303/AssignColorsCalendarOutlook3.webp" title="Conditioning formatting in calendar" width="400" /></a><br /></div><br />
</div><div style="text-align: justify;">
</div>
<div style="text-align: justify;">
The list of the rules already registered will be shown with the color assigned to each of them.</div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3_HfuUEMelzBh3Bx51monF1mMG7fAmhZxkSKK6gPdY10eqHgP_mJr5IKfWxINsb35oo-LTJ4Pxvp19tJokYRWRfLEHvZo2uvcs5H6h5wAD63S579GsBbBb2VIh1y20W1mp2ZaC_WU-Nr0gWurtKeyWgFwvpRpsiDI0wQbDlkzcfxRKLTe76dtpcVN/s494/AssignColorsCalendarOutlook4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="List color formatting" border="0" data-original-height="371" data-original-width="494" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3_HfuUEMelzBh3Bx51monF1mMG7fAmhZxkSKK6gPdY10eqHgP_mJr5IKfWxINsb35oo-LTJ4Pxvp19tJokYRWRfLEHvZo2uvcs5H6h5wAD63S579GsBbBb2VIh1y20W1mp2ZaC_WU-Nr0gWurtKeyWgFwvpRpsiDI0wQbDlkzcfxRKLTe76dtpcVN/w400-h300/AssignColorsCalendarOutlook4.webp" title="List color formatting" width="400" /></a><br /></div><br />
</div><div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Click on 'Add' and complete the field 'Name:' and select a color for this new rule. Then, click on 'Condition...'.</div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig25hyjsFyyLs_5rBndK0CT0Ox0RviFEN85HIJzs4eVboy8lGWhY16K3hYFaG1xxEOSjnbkrLTjAjPT_VceoU2lRCdHq4MGsRr66CMVnAyJWYoaGiIX6BrcxA97Kts-BzThHUz44i_U2CK0kTSB8r4v5GZU8b6bMmhsvAsntW6NfC0bLlYiSmXHSV6/s509/AssignColorsCalendarOutlook5.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Add condition for formatting" border="0" data-original-height="352" data-original-width="509" height="276" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig25hyjsFyyLs_5rBndK0CT0Ox0RviFEN85HIJzs4eVboy8lGWhY16K3hYFaG1xxEOSjnbkrLTjAjPT_VceoU2lRCdHq4MGsRr66CMVnAyJWYoaGiIX6BrcxA97Kts-BzThHUz44i_U2CK0kTSB8r4v5GZU8b6bMmhsvAsntW6NfC0bLlYiSmXHSV6/w400-h276/AssignColorsCalendarOutlook5.webp" title="Add condition for formatting" width="400" /></a><br /></div><br />
</div><div style="text-align: justify;">
</div>
<div style="text-align: justify;">
There, you can set the filter for the events that will have the selected color by using different criteria.</div> <div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiINWFnk9y0bmS7JATdCaHZM0hdpVF3quKvCMaZO_aKkV4QcZUPciFM1nReKN-EsIPOKPyBAn6j7Ag_Cy4NUOvGEEXIzPSH4mcLo1Ziw4MQMzXbPiwZwA3JsK-0ICC2nn4-Amoid0Sod1RV1XAIYRpCFh11p1gcS5qsMQvEujHINXvI7jo62-yFw5K2/s497/AssignColorsCalendarOutlook6.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Set the filter for the calendar events" border="0" data-original-height="360" data-original-width="497" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiINWFnk9y0bmS7JATdCaHZM0hdpVF3quKvCMaZO_aKkV4QcZUPciFM1nReKN-EsIPOKPyBAn6j7Ag_Cy4NUOvGEEXIzPSH4mcLo1Ziw4MQMzXbPiwZwA3JsK-0ICC2nn4-Amoid0Sod1RV1XAIYRpCFh11p1gcS5qsMQvEujHINXvI7jo62-yFw5K2/w400-h290/AssignColorsCalendarOutlook6.webp" title="Set the filter for the calendar events" width="400" /></a></div></div><div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
Once the setting is finished Outlook will check each new item on the calendar to assign a color if it fits with the filters.</div>
<br />
<br />Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-76697527649121724022018-07-08T15:49:00.001+02:002022-04-03T17:37:53.281+02:00Alternative for Screenshoting in Windows<div style="text-align: justify;">
If the default way to get screenshots in <a href="https://www.microsoft.com/en-us/windows" target="_blank">Windows</a> is to basic for you, let me introduce you <a href="http://getgreenshot.org/" target="_blank">Greenshot</a>, a lightweight open source tool to make screenshots with the option to take a portion of the screen and then edit it.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Once you make the screenshot, it's saved in the clipboard so you can use the capture immediately, but if you want, you can right click in the application icon in the taskbar and open the editor:<br /></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbuebE4p5TAqph-4I_WpMLfw463VFb-41EKxKO9KdV1O2q29KYKHrXnuITlV72rxU59porMQqlyqx32MUN7KnFJJjdcwiDppvPVbUzt7rkBNmS4wucweOYxW5hmF2ExYQz2w3ZN3CDZYf5S9sIUaEHmJrcxRTvEaJk2EhMad1DWgY3bf-9q0z5W3Vd/s465/AlternativeScreenshotWindows1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Open image from screeshot" border="0" data-original-height="465" data-original-width="355" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbuebE4p5TAqph-4I_WpMLfw463VFb-41EKxKO9KdV1O2q29KYKHrXnuITlV72rxU59porMQqlyqx32MUN7KnFJJjdcwiDppvPVbUzt7rkBNmS4wucweOYxW5hmF2ExYQz2w3ZN3CDZYf5S9sIUaEHmJrcxRTvEaJk2EhMad1DWgY3bf-9q0z5W3Vd/w305-h400/AlternativeScreenshotWindows1.webp" title="Open image from screeshot" width="305" /></a><br /></div></div>
<br />
And add some marks and more: <br /><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAAIQhqpYbPR2xKjq4sMgTx6ruQXJsKZ9a1pbINveYzY8vFonEl5BnhPtFjssgTj34ILZBrlEdfxHCQ_-dEEZRP-50QOsbaY7-HTEwMms9rB7FbfPgobKeTdYT01-4R1_8dsk23N5I_-Ek_2FC-NelsBE-puAWigFLnob1YMThsdISsX2UDMyVHz0v/s637/AlternativeScreenshotWindows2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Edit screenshot" border="0" data-original-height="622" data-original-width="637" height="390" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAAIQhqpYbPR2xKjq4sMgTx6ruQXJsKZ9a1pbINveYzY8vFonEl5BnhPtFjssgTj34ILZBrlEdfxHCQ_-dEEZRP-50QOsbaY7-HTEwMms9rB7FbfPgobKeTdYT01-4R1_8dsk23N5I_-Ek_2FC-NelsBE-puAWigFLnob1YMThsdISsX2UDMyVHz0v/w400-h390/AlternativeScreenshotWindows2.webp" title="Edit screenshot" width="400" /></a><br /></div><br /></div><div style="text-align: justify;">
It's straightforward and has many options like capturing the mouse pointer, notifications, sound, default destination and more:<br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl_K0q3wD2q0pNq5Q5SYe7TiA9ft4YVJtwtf_xrRLDGNDYcnHFNQy7IZd968cjoh62jbvCf1EgzMKSgqwTHDVT6nCYdoE37R616V9P3KL-EyhUNVGVZ6hvLk-Sy43XeiGFr9am8BcXH9D93-517Y6yNf8i22A9KuVKzH2Pp-JAtoXmv4_0r4qU0o7B/s452/AlternativeScreenshotWindows3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Settings for screenshoting" border="0" data-original-height="202" data-original-width="452" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjl_K0q3wD2q0pNq5Q5SYe7TiA9ft4YVJtwtf_xrRLDGNDYcnHFNQy7IZd968cjoh62jbvCf1EgzMKSgqwTHDVT6nCYdoE37R616V9P3KL-EyhUNVGVZ6hvLk-Sy43XeiGFr9am8BcXH9D93-517Y6yNf8i22A9KuVKzH2Pp-JAtoXmv4_0r4qU0o7B/w400-h179/AlternativeScreenshotWindows3.webp" title="Settings for screenshoting" width="400" /></a></div></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5iXANJHpgPEzZ1KLmxMl99ja5kJMB_6VfsZFRAzrg3iywg_ukafp97I8CX3BZcQFQhvQGoXC3eiMvBawx_3OaCnDn2GxoocupGL1ZOnUZizjaqlr6rBzIjPN1IDmbiFrntdT8yH9NGioy4Xb9Y23Isxci9562zX0R_GnOyjacgDbTL15eAQnuhMHo/s458/AlternativeScreenshotWindows4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="More settings for screenshoting" border="0" data-original-height="458" data-original-width="453" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5iXANJHpgPEzZ1KLmxMl99ja5kJMB_6VfsZFRAzrg3iywg_ukafp97I8CX3BZcQFQhvQGoXC3eiMvBawx_3OaCnDn2GxoocupGL1ZOnUZizjaqlr6rBzIjPN1IDmbiFrntdT8yH9NGioy4Xb9Y23Isxci9562zX0R_GnOyjacgDbTL15eAQnuhMHo/w396-h400/AlternativeScreenshotWindows4.webp" title="More settings for screenshoting" width="396" /></a><br /></div>
<br />
<div style="text-align: justify;">
I use this tool as it's really practical, with many options and doesn't eat your memory, very recommendable. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-21511261959757120962018-05-10T20:52:00.002+02:002022-04-03T17:25:59.025+02:00Changing the color of the text when replying email in Outlook<div style="text-align: justify;">
If you use <a href="https://outlook.live.com/owa/" target="_blank">Microsoft Outlook</a> in your computer, you should have this application configured to reply emails by using blue fonts (not black):</div>
<div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIACxGGJPjj009Ib-C1nGZbwKrFm0Uy9TSD05bVrVmJhRP99sLwwe2SkFdQ-oY15a0byDhuX18yR_ylIufSfzvtHFg9v1m-8b5oVbRUyKW0y3DCm5JFBs7o15toD0ayGeS5X5LA7kjuMYABG_7Z4_tl_uxt0yvkSgE3FdEkB7FxbPWcYbkwWcgtPcJ/s947/ChangeColorTextOutlook1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Reply in different color in Outlook" border="0" data-original-height="710" data-original-width="947" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIACxGGJPjj009Ib-C1nGZbwKrFm0Uy9TSD05bVrVmJhRP99sLwwe2SkFdQ-oY15a0byDhuX18yR_ylIufSfzvtHFg9v1m-8b5oVbRUyKW0y3DCm5JFBs7o15toD0ayGeS5X5LA7kjuMYABG_7Z4_tl_uxt0yvkSgE3FdEkB7FxbPWcYbkwWcgtPcJ/w640-h480/ChangeColorTextOutlook1.webp" title="Reply in different color in Outlook" width="640" /></a></div><br />
</div><div style="text-align: justify;">
</div>
<div style="text-align: justify;">
To change this, just go 'File' and select 'Options' on the left:</div>
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-36TiIMwyziafzS4F0mh-ZVRIbbY-_GjFZm_fPXKYAERkPy1hUX04qMBvhS-CLx2p01zbIQS_UGdHKQppr5gxdfN9JRS-FW6MfLheuFJAMkVtLVPzbcffjZkLQlUrVftelkUl7wmmkStk0KHp0BHCZPoMLXY60KDYboYaRwUBARFY2UNPXFi_Q-oB/s864/ChangeColorTextOutlook2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to options in Outlook" border="0" data-original-height="488" data-original-width="864" height="361" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-36TiIMwyziafzS4F0mh-ZVRIbbY-_GjFZm_fPXKYAERkPy1hUX04qMBvhS-CLx2p01zbIQS_UGdHKQppr5gxdfN9JRS-FW6MfLheuFJAMkVtLVPzbcffjZkLQlUrVftelkUl7wmmkStk0KHp0BHCZPoMLXY60KDYboYaRwUBARFY2UNPXFi_Q-oB/w640-h361/ChangeColorTextOutlook2.webp" title="Go to options in Outlook" width="640" /></a></div><br />
</div><div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Then, go to 'Mail' and click on 'Stationery and Fonts...':</div>
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAXMsNgK7bB-Vd2BzrkqvBckSSt_t-x16qnsdCWz-Jgrm_hluEu0wWnCMYLi_OznTCQ9jJ0zY4GjIm2iC-T6kluLgbIlDcjVGFOFYNGsQst3p-PE7iseZC9K56V7KjoHXs45lvuy5n4IXkfzLey-R4iagLSLOaSMuX2OIea37rdHbKckyse5dBFYVR/s909/ChangeColorTextOutlook3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to Fonts" border="0" data-original-height="506" data-original-width="909" height="356" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAXMsNgK7bB-Vd2BzrkqvBckSSt_t-x16qnsdCWz-Jgrm_hluEu0wWnCMYLi_OznTCQ9jJ0zY4GjIm2iC-T6kluLgbIlDcjVGFOFYNGsQst3p-PE7iseZC9K56V7KjoHXs45lvuy5n4IXkfzLey-R4iagLSLOaSMuX2OIea37rdHbKckyse5dBFYVR/w640-h356/ChangeColorTextOutlook3.webp" title="Go to Fonts" width="640" /></a></div><br />
</div><div style="text-align: justify;">
</div>
<div style="text-align: justify;">
In the new window, you will have fonts configuration, select the one in the section 'Replying or forwarding messages' and set the fonts as you like:</div>
<div class="separator" style="clear: both; text-align: center;"> <a href="https://4.bp.blogspot.com/-nopHAoKJu3o/WvSQhSmAjYI/AAAAAAAACUo/ShAHiHb1dKcMYt41XuK20JZl0H2d2Ws9ACLcBGAs/s1600/Color4.png" style="margin-left: 1em; margin-right: 1em;"></a> <br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtUWK5bb8EMU9PxtCICneei9H9YVP-pUh9oVbguk3c1U5bWTct-WkpwbL0jPc3NzoCgxtze3gRNQxFkHRFpTA3fNP_5-GWpXWryPs_mlKtI0TqTsf7O2xN2mymbuhZCIeDcHqpvl-Oih44phrLXXpp2RJn1GoWgVvkUTbJIYGRO9JY1qwF-55wWcIA/s762/ChangeColorTextOutlook4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Change replying text format" border="0" data-original-height="596" data-original-width="762" height="500" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtUWK5bb8EMU9PxtCICneei9H9YVP-pUh9oVbguk3c1U5bWTct-WkpwbL0jPc3NzoCgxtze3gRNQxFkHRFpTA3fNP_5-GWpXWryPs_mlKtI0TqTsf7O2xN2mymbuhZCIeDcHqpvl-Oih44phrLXXpp2RJn1GoWgVvkUTbJIYGRO9JY1qwF-55wWcIA/w640-h500/ChangeColorTextOutlook4.webp" title="Change replying text format" width="640" /></a> <br /></div>
<br />
Now, when you reply or forward an email you will use the font as you set it.<br />
<br />
<br />Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-89352900669100187822018-02-03T01:14:00.001+01:002022-04-03T16:36:55.442+02:00Using INDIRECT in Excel<div style="text-align: justify;">
The INDIRECT function in <a href="https://products.office.com/en/excel" target="_blank">Excel</a> allows you to reference cells by typing the cell position (for instance: "B2"). To clarify this, look at the first example, you can see in the function bar that it's a direct reference. <a href="https://3.bp.blogspot.com/-FpS6UcVgPlc/WnTj-wdp2kI/AAAAAAAACRw/-hTm86MjhNg9uSqcoDM6i7IaR8KVd1XbACLcBGAs/s1600/Sans%2Btitre1.png" style="margin-left: 1em; margin-right: 1em;"></a><br /></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtdKnDCIPoSz0wrMJcJ68YGu1p1YstenuMruvCp6HfWRV8GQbLgiVBLmKju_wKRK7mKoXjvyaLE5bf24uJEGWcSCxhTxO3LssYEPdSjumUJ7O_3pyr-6clol7LGVR14ZyGfkFQ3bxYwzqHSqccJvp_4EFljhyqYovl6ojLhplLkw-INxZjQ9YKA-EM/s683/UseIndirect1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Get cell location" border="0" data-original-height="615" data-original-width="683" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtdKnDCIPoSz0wrMJcJ68YGu1p1YstenuMruvCp6HfWRV8GQbLgiVBLmKju_wKRK7mKoXjvyaLE5bf24uJEGWcSCxhTxO3LssYEPdSjumUJ7O_3pyr-6clol7LGVR14ZyGfkFQ3bxYwzqHSqccJvp_4EFljhyqYovl6ojLhplLkw-INxZjQ9YKA-EM/w400-h360/UseIndirect1.webp" title="Get cell location" width="400" /></a><br /></div><br /></div>
<div style="text-align: justify;">
In the following example, the indirect function is used with the parameter "D3" as text and brings the same result.<br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj525bHXAcxJgJLsGJzT43PUl54n0_Eu8XhdObruDU3ZK38Xqc6usTOv4iS1zSHAWwBesNVD72Pdn1O1vY_OXl25RBZHGyIeoLrhZbC0EUlyJmwyUPDSEU11jswVR2s2tH9uFC9l5UwwnsUnrut2vYsLQF9z6DgipRtttPMmiV4sVrtcxRwMSBxEUAD/s683/UseIndirect2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Use indirect function" border="0" data-original-height="614" data-original-width="683" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj525bHXAcxJgJLsGJzT43PUl54n0_Eu8XhdObruDU3ZK38Xqc6usTOv4iS1zSHAWwBesNVD72Pdn1O1vY_OXl25RBZHGyIeoLrhZbC0EUlyJmwyUPDSEU11jswVR2s2tH9uFC9l5UwwnsUnrut2vYsLQF9z6DgipRtttPMmiV4sVrtcxRwMSBxEUAD/w400-h360/UseIndirect2.webp" title="Use indirect function" width="400" /></a><br /></div><br /></div>
Now, as the parameter of the indirect function is text, you can concatenate and build the cell reference by using other cells. <a href="https://4.bp.blogspot.com/-Ix-1i8PnLT4/WnTj-6IXEaI/AAAAAAAACRs/RH-Auo6Lr4gdGft6r1vB0irPnFRxFNiiQCLcBGAs/s1600/Sans%2Btitre3.png" style="margin-left: 1em; margin-right: 1em;"><br /></a><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiag5T1fmg3fVSGceeX20cbB5sEmObOKufItNWP_A8KwNLmKI_eHXBEV_gy3A84BP1oM8XE6Ci36jEzIfZCv1IllOoR66W5hX1SFxmDh03sZ-CogtFeQKWQSbmPWmWlFOJjVLClGul_FaZ4PmipuX7JlWsGViNGn57ojENj6QocmHZRb3E7rUWwqYA/s683/UseIndirect3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Concatenate cell references" border="0" data-original-height="615" data-original-width="683" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiag5T1fmg3fVSGceeX20cbB5sEmObOKufItNWP_A8KwNLmKI_eHXBEV_gy3A84BP1oM8XE6Ci36jEzIfZCv1IllOoR66W5hX1SFxmDh03sZ-CogtFeQKWQSbmPWmWlFOJjVLClGul_FaZ4PmipuX7JlWsGViNGn57ojENj6QocmHZRb3E7rUWwqYA/w400-h360/UseIndirect3.webp" title="Concatenate cell references" width="400" /></a><br /></div>
<br />
<div style="text-align: justify;">
It's clear that using a direct reference (example 1) is better than using the indirect function, however, there are cases where is required to build functions dynamically depending on other values and the indirect function is a great tool to consider for these situations.</div>
<br />
Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-19959523031941390852017-10-29T14:06:00.001+01:002022-08-20T10:55:20.077+02:00Why is the Delete Worksheet Option Disabled in Excel?<div style="text-align: justify;">
In <a href="https://products.office.com/en/excel" target="_blank">Excel</a> you have to option to delete worksheets as soon as you realize that you don't need it anymore, this can be easily done by right-clicking on the tab you want to delete and select this action. However, sometimes you will see that this option is not enabled.</div><div class="separator" style="clear: both; text-align: center;"> <a href="https://1.bp.blogspot.com/-omvnsjFDLEs/WfWeuTUfWlI/AAAAAAAACPM/DJbIO9_5lSo5Z5Aslm4INPHtJ68mAgUEgCLcBGAs/s1600/Eliminar1.png" style="margin-left: 1em; margin-right: 1em;"><br /></a></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvKeRC8gRjaJ0NtM7vvFheMeRUTkvnFoySi_ZA8se7mIyWxtfB6Lp442NZoPTTb_y2qdNXZt41R17zy_jX80OTdh-0TyNPqexfdRwGkssRJ4i6AadSwpguHXj3HoCSQNW0rpRmt7ImhS_vicjBaZC5j9qpOhATfkQE_0qSKSAJhCO5RgI9yJ-WYP8K/s1342/Eliminar1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Delete spreadsheet not enabled" border="0" data-original-height="858" data-original-width="1342" height="409" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvKeRC8gRjaJ0NtM7vvFheMeRUTkvnFoySi_ZA8se7mIyWxtfB6Lp442NZoPTTb_y2qdNXZt41R17zy_jX80OTdh-0TyNPqexfdRwGkssRJ4i6AadSwpguHXj3HoCSQNW0rpRmt7ImhS_vicjBaZC5j9qpOhATfkQE_0qSKSAJhCO5RgI9yJ-WYP8K/w640-h409/Eliminar1.webp" title="Delete spreadsheet not enabled" width="640" /></a></div><br /></div>
<div style="text-align: justify;">
This option is disabled when the workbook is shared, so more people can collaborate to the file at the same time, this situation is shown in the title of the file, this will include '(Shared)'.</div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnbBDagcWhgVdzXt-5SNMeG6km7Jd1ZBaM1uaerhlVpQ81DF1kCdcgATuEX8TZr-MtBxEY__H2XvaWAm2n6ocNsAvewsAACPZF6jSDraFqMAI8j8_W4C4YunZTH6JNDpUzRAzaOHiNTKci1aWdYHxGNy1QIFQ1pUEl10b4wpz8o8JJ8qltJdfNE-II/s1340/Eliminar2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Shared in Excel title" border="0" data-original-height="186" data-original-width="1340" height="88" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnbBDagcWhgVdzXt-5SNMeG6km7Jd1ZBaM1uaerhlVpQ81DF1kCdcgATuEX8TZr-MtBxEY__H2XvaWAm2n6ocNsAvewsAACPZF6jSDraFqMAI8j8_W4C4YunZTH6JNDpUzRAzaOHiNTKci1aWdYHxGNy1QIFQ1pUEl10b4wpz8o8JJ8qltJdfNE-II/w640-h88/Eliminar2.webp" title="Shared in Excel title" width="640" /></a> </div>
<br />
<div style="text-align: justify;">
To disable the shared property of the workbook go to 'Review' ribbon and select 'Share Workbook' option.</div>
<div class="separator" style="clear: both; text-align: center;"> <a href="https://1.bp.blogspot.com/-MpLTz4ofPUI/WfWeuXuYJII/AAAAAAAACPI/3vccI5kEU-YnfvCxBTXbEX3kNUXNc4BNgCLcBGAs/s1600/Eliminar3.png" style="margin-left: 1em; margin-right: 1em;"><br /></a></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6eVt1hBeWjGf2V5h2U95wH3xTVAcucoINsn8FryCEGVOaphsuvmKp9wgeEOv8vz2zt2sz6CNUyPU500mNppsv-MFw4QC72Za0LFd6rOqCVq_rA96YzxxpzgcXN8S01SymYqytS5wLosxpxfH-Ayv-X5nHe3uKSLflbRBgrLqKyUABUJ4bvkrErHSo/s1504/Eliminar3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to Share Workbook option" border="0" data-original-height="312" data-original-width="1504" height="132" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6eVt1hBeWjGf2V5h2U95wH3xTVAcucoINsn8FryCEGVOaphsuvmKp9wgeEOv8vz2zt2sz6CNUyPU500mNppsv-MFw4QC72Za0LFd6rOqCVq_rA96YzxxpzgcXN8S01SymYqytS5wLosxpxfH-Ayv-X5nHe3uKSLflbRBgrLqKyUABUJ4bvkrErHSo/w640-h132/Eliminar3.webp" title="Go to Share Workbook option" width="640" /></a> <br /></div>
<br />
<div style="text-align: justify;">
Then, you will see the list of users that have the workbook open, once you uncheck the 'Allow changes by more than one user at the same time...' box and accept, the workbook will lose its shared property.<br /></div>
<div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaxlxjfoCucuG1Mi5MOqp41uFthODFYvR9ChuInLqDFENQvpy6wKQ8am5JVqkxj8Re6belHrrKy3bvfZps0ycfg1X5kC2u2jtKDFha084XTDV3C7qc1BxlQBsIUoaJGDCSBp8brdIEwTzCG1uZMP7Lv-vi0A_ZYRX2SMB3xCKBM4Dm30rxUQotJo3P/s430/Eliminar4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Disable allow changes from other users" border="0" data-original-height="430" data-original-width="374" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaxlxjfoCucuG1Mi5MOqp41uFthODFYvR9ChuInLqDFENQvpy6wKQ8am5JVqkxj8Re6belHrrKy3bvfZps0ycfg1X5kC2u2jtKDFha084XTDV3C7qc1BxlQBsIUoaJGDCSBp8brdIEwTzCG1uZMP7Lv-vi0A_ZYRX2SMB3xCKBM4Dm30rxUQotJo3P/w348-h400/Eliminar4.webp" title="Disable allow changes from other users" width="348" /></a> <br /></div>
<br />
<div style="text-align: justify;">
After this, you try again and notice that the 'Delete' option is enabled again and ready to use.<br /></div>
<div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqnju6FPralzbT5k4jiG6NW4GlZhNnaV_XzdRr1oJ2tLjgg4cVPhJZBFJBYpgBR9fHzhSNOmJakgMIrshoXNM13vc6C-30_K9KRwV-HTF5xVM-Gy6U3QzBpLvhOPNsf9qcoyfY9HRRfHyQgsy-iu88xBvpuaGgVGpsrH1AFfJFJeiYURveI9tNTlJM/s748/Eliminar5.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Delete tab option enabled again" border="0" data-original-height="748" data-original-width="604" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqnju6FPralzbT5k4jiG6NW4GlZhNnaV_XzdRr1oJ2tLjgg4cVPhJZBFJBYpgBR9fHzhSNOmJakgMIrshoXNM13vc6C-30_K9KRwV-HTF5xVM-Gy6U3QzBpLvhOPNsf9qcoyfY9HRRfHyQgsy-iu88xBvpuaGgVGpsrH1AFfJFJeiYURveI9tNTlJM/w516-h640/Eliminar5.webp" title="Delete tab option enabled again" width="516" /></a> <br /></div><p>
<br />
Consider that the 'Shared Worksheet' option is not anymore recommended in newer versions of Excel, use co-authoring instead.<br />
</p><p><br /></p>Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-18710854815554511282017-09-17T17:48:00.002+02:002022-08-20T13:31:19.409+02:00Preventing Excel File to Open or Edit with Password
<style type="text/css">p { margin-bottom: 0.25cm; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "Calibri"; font-size: 11pt; }p.ctl { font-size: 11pt; }</style>
<br />
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;">
When
you have an <a href="https://products.office.com/en/excel" target="_blank">Excel</a> file and don’t want everyone to open or edit it
but only specific people then you could protect the file with a
password. To do this, you have to use the ‘Save As...’ option and
select ‘Browser’:</div>
<div class="separator" style="clear: both; text-align: center;"> <a href="https://3.bp.blogspot.com/-PhAbY4wQDQM/Wb6TEOZhaHI/AAAAAAAACNE/hmQUZ46VOd0ViqILhez9K3oJM0WiYm6uACLcBGAs/s1600/Sans%2Btitre1.png" style="margin-left: 1em; margin-right: 1em;"></a> <br /></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit4RD0839RAJ57M6y19k3Nc6sY300mVDE8n60vjdQmUjzCFbR0D8Ihm9b_TTpK91tkB-_Wmta6wu5I1ozNit-sHwjKwDms0SZG5i_NTw_Dn1qc3vFKsaqH1V1RuixgCuKCv8wKVny95UCPH-0SvdJWb5BrHFWPmsFg6mUxQdp7IC-fHrpsxb2l_E7P/s1364/ProtectExcelPassword1.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Save the Excel file" border="0" data-original-height="724" data-original-width="1364" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit4RD0839RAJ57M6y19k3Nc6sY300mVDE8n60vjdQmUjzCFbR0D8Ihm9b_TTpK91tkB-_Wmta6wu5I1ozNit-sHwjKwDms0SZG5i_NTw_Dn1qc3vFKsaqH1V1RuixgCuKCv8wKVny95UCPH-0SvdJWb5BrHFWPmsFg6mUxQdp7IC-fHrpsxb2l_E7P/w640-h340/ProtectExcelPassword1.webp" title="Save the Excel file" width="640" /></a></div><br /></div><div class="western" style="line-height: 108%; margin-bottom: 0.28cm;">
In
the typical window to save the file, go to ‘Tools’ option and
then select ‘General Options...’:</div><div class="separator" style="clear: both; text-align: center;"> <a href="https://3.bp.blogspot.com/-oHvGYVbYWbU/Wb6TFiJw-xI/AAAAAAAACNI/ujCXYcXyo9U1hS1bN1gdl1akjEAZcEn5ACEwYBhgL/s1600/Sans%2Btitre2.png" style="margin-left: 1em; margin-right: 1em;"><br /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl4FxxqIYH6m2_H5cU4qJyhZ2fvD7DkgZo0yCPKcslrgcSmb42JAGACDN9zs3RCjpDGN39PSkyhNFRzDOvHPb0RoaD1LKA30wHnl3xT5lmVLqaoBmOOaZtqjdoxIw7MSkpN3IUV_l9NOTekwKa6r_-xX_z09-Qf-gOwPSG9NPuTWCpt70xiOUGcqn-/s1366/ProtectExcelPassword2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Go to General Options" border="0" data-original-height="724" data-original-width="1366" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl4FxxqIYH6m2_H5cU4qJyhZ2fvD7DkgZo0yCPKcslrgcSmb42JAGACDN9zs3RCjpDGN39PSkyhNFRzDOvHPb0RoaD1LKA30wHnl3xT5lmVLqaoBmOOaZtqjdoxIw7MSkpN3IUV_l9NOTekwKa6r_-xX_z09-Qf-gOwPSG9NPuTWCpt70xiOUGcqn-/w640-h340/ProtectExcelPassword2.webp" title="Go to General Options" width="640" /></a> <br /></div>
<br />
<div style="text-align: justify;">
<style type="text/css">p { margin-bottom: 0.25cm; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "Calibri"; font-size: 11pt; }p.ctl { font-size: 11pt; }</style>
</div>
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;">
With
that selection, you will be able to set a password that will be asked
when opening or editing the file, without the right password the file
will not open or edit: <br /></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQmI0jkn2vUWnFB6-FdxCR-mZkCBB6LdCXHjf8P_GZ3x1fTMHFuuS-3Dk9LM-cIjU7AcKTjGsKA3YLaq1gZBaUUmFYQqBRfK2Ap13yBI6n3rCr5FcbljLEWHKTJpwFXC5w3y2ng9iZrL35hZJ-HhZttbII5KuGj5jJzTtsE2oD5jcJUaSFYP73NVbR/s1364/ProtectExcelPassword3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Set password for Excel" border="0" data-original-height="726" data-original-width="1364" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQmI0jkn2vUWnFB6-FdxCR-mZkCBB6LdCXHjf8P_GZ3x1fTMHFuuS-3Dk9LM-cIjU7AcKTjGsKA3YLaq1gZBaUUmFYQqBRfK2Ap13yBI6n3rCr5FcbljLEWHKTJpwFXC5w3y2ng9iZrL35hZJ-HhZttbII5KuGj5jJzTtsE2oD5jcJUaSFYP73NVbR/w640-h340/ProtectExcelPassword3.webp" title="Set password for Excel" width="640" /></a> <br /></div>
<style type="text/css">p { margin-bottom: 0.25cm; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "Calibri"; font-size: 11pt; }p.ctl { font-size: 11pt; }</style>
<br />
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm;">
This
is the popup that will appear to anyone after setting the protection: <br /></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9P-9-ZgNlqebLyWPW2jxbz2TJh4F6cplnE-gk-nb_VUA7wKUzhvbzJHkNWAjF2yFcubdCRpEt1h8ohsPqaw-BMdHtYeySPwynaKwd68NveBj4TMke54llpnGJstaHPdXzATFy3Sl4ethMWhHdzl8zm8hcw5l3AWkHGn95F2hLdnd_rgM-l7lR3XfA/s1365/ProtectExcelPassword4.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Pop-up asking the password for Excel" border="0" data-original-height="729" data-original-width="1365" height="342" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9P-9-ZgNlqebLyWPW2jxbz2TJh4F6cplnE-gk-nb_VUA7wKUzhvbzJHkNWAjF2yFcubdCRpEt1h8ohsPqaw-BMdHtYeySPwynaKwd68NveBj4TMke54llpnGJstaHPdXzATFy3Sl4ethMWhHdzl8zm8hcw5l3AWkHGn95F2hLdnd_rgM-l7lR3XfA/w640-h342/ProtectExcelPassword4.webp" title="Pop-up asking the password for Excel" width="640" /></a> <br /></div>
<style type="text/css">p { margin-bottom: 0.25cm; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "Calibri"; font-size: 11pt; }p.ctl { font-size: 11pt; }</style> <br />
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;">
Also,
you can use this option to set a recommendation when opening the file
to use it as read-only, to do this just check the box ‘Recommend as
read-only’ located under the password box, then when opening the
file will always show this: <br /></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTGQGMp_uiWOVHHv5ewoxuyRI9lwYGRWzuqeOa3Gybc6J0pqmbIrB06cTBj95FNdmOTySx7KW7xNwLmtxfx6zQozYJknenFT232tI36AgzzyOLG1_cSXGVCFT7EVsSnIFCgPhK-8WPFoiudWkNX-YbQlDdCTQcPvPOfzOud7rwB-6N0Y3DLPzTF9eM/s1366/ProtectExcelPassword5.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Input the password to open the Excel file" border="0" data-original-height="726" data-original-width="1366" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTGQGMp_uiWOVHHv5ewoxuyRI9lwYGRWzuqeOa3Gybc6J0pqmbIrB06cTBj95FNdmOTySx7KW7xNwLmtxfx6zQozYJknenFT232tI36AgzzyOLG1_cSXGVCFT7EVsSnIFCgPhK-8WPFoiudWkNX-YbQlDdCTQcPvPOfzOud7rwB-6N0Y3DLPzTF9eM/w640-h340/ProtectExcelPassword5.webp" title="Input the password to open the Excel file" width="640" /></a> </div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCdd_qv0uP0pIetqt4u1YNDQ56U_dZhm2s-RPqSzkd79fCKMihD_vzQzYG7_aUZ6p0AQhCE9-XzTz0XgpgbiDgJDpI_WIssAwoKrf7-ygSVb3NY2_tbHN5FzyG1LNe9QfXeraO3Z6mjavIYBwTt9pq_TGZ5ilRQs0nRjWL16aadXM543TL-oKlMxGP/s1366/ProtectExcelPassword6.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Open the Excel file as read-only" border="0" data-original-height="723" data-original-width="1366" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCdd_qv0uP0pIetqt4u1YNDQ56U_dZhm2s-RPqSzkd79fCKMihD_vzQzYG7_aUZ6p0AQhCE9-XzTz0XgpgbiDgJDpI_WIssAwoKrf7-ygSVb3NY2_tbHN5FzyG1LNe9QfXeraO3Z6mjavIYBwTt9pq_TGZ5ilRQs0nRjWL16aadXM543TL-oKlMxGP/w640-h338/ProtectExcelPassword6.webp" title="Open the Excel file as read-only" width="640" /></a> <br /></div>
<br />
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm;">
This
read-only function can be used without setting a password.</div>
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm;">
<br /></div><div class="western" style="line-height: 108%; margin-bottom: 0.28cm;">
<br /></div>
Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0tag:blogger.com,1999:blog-5739196489377544228.post-35617689649292954012017-09-12T09:53:00.004+02:002022-08-20T21:35:52.383+02:00Fixing Excel When Scrolling Sheet Instead of Moving Cell Selector<style type="text/css">p { margin-bottom: 0.25cm; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "Calibri"; font-size: 11pt; }p.ctl { font-size: 11pt; }</style>
<br />
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;">
<span style="font-family: inherit;">When
you have in <a href="https://products.office.com/en/excel" target="_blank">Excel</a> your cells like this:</span></div><div class="separator" style="clear: both; text-align: center;"> </div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0mAF4GtWRyMkOd-3VW-Dp_LoNHv4NV2ydl_s6U325QSoq3R4-Qu5ZSUzlD2CqOIiTgKM7Sjs_3YAxzzvDVfWRFDYKqmV331BePqc6KkPZ0oNQ5IqVBpr10K_DsE2oBcTrOyyd6PMvOLjgS2deKzVISxdyb6q886SFc0e4wTPsjHJyEXMRhRS5_Y1n/s1366/FixScrollCellExcel1.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Excel cells with text" border="0" data-original-height="727" data-original-width="1366" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0mAF4GtWRyMkOd-3VW-Dp_LoNHv4NV2ydl_s6U325QSoq3R4-Qu5ZSUzlD2CqOIiTgKM7Sjs_3YAxzzvDVfWRFDYKqmV331BePqc6KkPZ0oNQ5IqVBpr10K_DsE2oBcTrOyyd6PMvOLjgS2deKzVISxdyb6q886SFc0e4wTPsjHJyEXMRhRS5_Y1n/w640-h340/FixScrollCellExcel1.webp" title="Excel cells with text" width="640" /></a></span></span></span> </span></span></span> </div>
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm;">
<span style="font-family: inherit;">
<style type="text/css">p { margin-bottom: 0.25cm; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "Calibri"; font-size: 11pt; }p.ctl { font-size: 11pt; }</style>
</span></div>
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;">
<br />
And
use the arrows on the keyboard to move to the right, for example, you
will move the cell selector to the right cell:<br />
</div>
<br />
<div class="separator" style="clear: both; text-align: center;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGnqB4vwVhBKHFxT724vWxLaUP5N2Ie5mqdn1zSffFUrZwYJaTkgp4IwSXWXWAld4u_BKv6zvrvV8BjY1atq9rZIJb5Kn0eXNob6UiZ--6ynva4cullDB1YsAkSnSy-nF76gO7dcAJiyqDkKi7mR0yHnHA4MSdvwM57y2Nn7EIvR2ohipbAvCHYM9I/s1363/FixScrollCellExcel2.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Move cell selector with arrow keys" border="0" data-original-height="726" data-original-width="1363" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGnqB4vwVhBKHFxT724vWxLaUP5N2Ie5mqdn1zSffFUrZwYJaTkgp4IwSXWXWAld4u_BKv6zvrvV8BjY1atq9rZIJb5Kn0eXNob6UiZ--6ynva4cullDB1YsAkSnSy-nF76gO7dcAJiyqDkKi7mR0yHnHA4MSdvwM57y2Nn7EIvR2ohipbAvCHYM9I/w640-h340/FixScrollCellExcel2.webp" title="Move cell selector with arrow keys" width="640" /> </a></span></span></span></span></span></span></span></div><div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;"> </div><div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;">However,
I have seen that in some cases the result is not that, instead, when
pressing the previous key the entire spreadsheet is scrolled to the
right, with the cell selector staying in the same place:</div><span style="font-family: inherit;"><span style="font-family: inherit;"><div class="separator" style="clear: both; text-align: center;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"> </span></span></span></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimDXo2m_ihp63sqFdly9Cus-QWtglanMM-09pmWYrfO5B8GcD0w2kGf01LBIJYbaif3eCIGxTRgf-7-JgJyuZ7lF-RIfYXu5vjrXuDIBwvnXHY1Vt3L45wdTn14fiX7I8nVakBeeg7USE8z22auRhKH8tTM3KhHnZdbWeqeACDLqE2NxF4N6hJO42F/s1365/FixScrollCellExcel3.webp" style="margin-left: 1em; margin-right: 1em;"><img alt="Arrow keys scrolls the spreadsheet" border="0" data-original-height="726" data-original-width="1365" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimDXo2m_ihp63sqFdly9Cus-QWtglanMM-09pmWYrfO5B8GcD0w2kGf01LBIJYbaif3eCIGxTRgf-7-JgJyuZ7lF-RIfYXu5vjrXuDIBwvnXHY1Vt3L45wdTn14fiX7I8nVakBeeg7USE8z22auRhKH8tTM3KhHnZdbWeqeACDLqE2NxF4N6hJO42F/w640-h340/FixScrollCellExcel3.webp" title="Arrow keys scrolls the spreadsheet" width="640" /></a></span></span></span> </span></span></span> </div></span></span><br />
<div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;">
<span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;">
<style type="text/css">p { margin-bottom: 0.25cm; direction: ltr; color: rgb(0, 0, 10); line-height: 120%; text-align: left; }p.western { font-family: "Calibri",serif; font-size: 11pt; }p.cjk { font-family: "Calibri"; font-size: 11pt; }p.ctl { font-size: 11pt; }</style></span></span></span> </div><div class="western" style="line-height: 108%; margin-bottom: 0.28cm; text-align: justify;">This
happens when the ‘Scroll Lock’ in pressed in the keyboard, then to
fix it just press it again, but nowadays many keyboards have no this
key, therefore, to fix this situation you should use the keyboard on
screen, to open this keyboard in <a href="https://www.microsoft.com/en-us/windows/" target="_blank">Windows</a> go to ‘Start’ and
search for ‘On-Screen Keyboard’, once you select it you will see
this:</div><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6tQ9tNMrZ5DqjLf0QpAOPe0A7LxGPgDWYUegPTfMOxxEtSB1-8EtTle5xIty9UXKVNMSe3owp5jGAU0PKfDcnlwKYQHlKcf0_3aYZtygWFcaA7CSZ5qlUyj__sYqQMpjigXfGVEHdeFUruSFYr5CXha5PkEftXtZPrPjLgiuEEk0TyTInoCOZi5-a/s1366/FixScrollCellExcel4.webp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Virtual keyboard in Windows" border="0" data-original-height="768" data-original-width="1366" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6tQ9tNMrZ5DqjLf0QpAOPe0A7LxGPgDWYUegPTfMOxxEtSB1-8EtTle5xIty9UXKVNMSe3owp5jGAU0PKfDcnlwKYQHlKcf0_3aYZtygWFcaA7CSZ5qlUyj__sYqQMpjigXfGVEHdeFUruSFYr5CXha5PkEftXtZPrPjLgiuEEk0TyTInoCOZi5-a/w640-h360/FixScrollCellExcel4.webp" title="Virtual keyboard in Windows" width="640" /></a></div> <br /></div></div></span></span></span><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"></span></span></span><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;"><div class="western" style="line-height: 108%; margin-bottom: 0.28cm;">You
see that the ‘Scroll Lock’ key is highlighted, click on it to
disable this function and close the keyboard, now you recovered the
usual behavior of the arrows keys in Excel.</div></span></span></span><span style="font-family: inherit;"><span style="font-family: inherit;"><span style="font-family: inherit;">
<span style="font-family: inherit;"><div class="western" style="line-height: 108%; margin-bottom: 0.28cm;">
<br /></div>
</span></span></span></span><br />
Ronald Mirandahttp://www.blogger.com/profile/02151694137050346413noreply@blogger.com0