tag:blogger.com,1999:blog-967828754174804049.post680172136790525564..comments2023-10-03T06:15:35.058-07:00Comments on Logically Proven: Hide or Show an Excel Ribbon - VBAKarthik Byggarihttp://www.blogger.com/profile/00511374732538276103noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-967828754174804049.post-10872532499476195052020-09-17T04:44:17.375-07:002020-09-17T04:44:17.375-07:00You made such an interesting piece to read, giving...You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us to read this... <a href="https://wpplugins.tips/hide-my-wordpress-ghost/" rel="nofollow">hide wp login url</a><br />SEOhttps://www.blogger.com/profile/15958270143733054273noreply@blogger.comtag:blogger.com,1999:blog-967828754174804049.post-23403994481618470072018-12-26T03:23:25.158-08:002018-12-26T03:23:25.158-08:00Here I can't share my email id. Please connect...Here I can't share my email id. Please connect on Google plus and let me know your questions.<br />Regards,<br />KarthikKarthik Byggarihttps://www.blogger.com/profile/00511374732538276103noreply@blogger.comtag:blogger.com,1999:blog-967828754174804049.post-61324374462066683752018-10-14T16:33:01.241-07:002018-10-14T16:33:01.241-07:00Hi Karthik,
Thanks for your feedback. Is it poss...Hi Karthik, <br /><br />Thanks for your feedback. Is it possible for you to share you email address so that I can ask follow up questions, if you don't mind.Anonymoushttps://www.blogger.com/profile/12377793671884479780noreply@blogger.comtag:blogger.com,1999:blog-967828754174804049.post-77107442539659546672018-09-23T23:46:27.869-07:002018-09-23T23:46:27.869-07:00Hi,
To show only on particular worksheet you must...Hi,<br /><br />To show only on particular worksheet you must use the worksheet activate event and call the macro inside the event with a true or false like below -<br /><br />If you activate the worksheet other than main sheet write the following code in the respective worksheet -<br /><br />Private Sub Worksheet_Activate()<br /><br />Application.ExecuteExcel4Macro "SHOW.TOOLBAR("Ribbon",True)<br /><br />End Sub<br /><br /><br />Karthik Byggarihttps://www.blogger.com/profile/00511374732538276103noreply@blogger.comtag:blogger.com,1999:blog-967828754174804049.post-11383468017648600202018-09-19T10:10:19.477-07:002018-09-19T10:10:19.477-07:00Hi Karthik,
Thanks for sharing your knowledge. Is...Hi Karthik,<br /><br />Thanks for sharing your knowledge. Is it possible for you to share a code which enables user to hide ribbon only for a single worksheet in a single workbook i.e. the ribbon remains hidden for the main menu sheet and becomes visible when all other sheets become visible after hitting command button (I have already created a separate code for visibility of worksheets).<br /><br />Just for your information, I am using excel in mac and I have tried the following code in Workbook_Open event in ThisWorkbook part of vba, however it is not working for me.<br /><br />Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"<br /><br />Thanks in advance for your help!Anonymoushttps://www.blogger.com/profile/12377793671884479780noreply@blogger.comtag:blogger.com,1999:blog-967828754174804049.post-24884820558426785592018-07-17T00:18:06.060-07:002018-07-17T00:18:06.060-07:00In the following article it is clearly explained h...In the following article it is clearly explained how to do that. <br />https://www.rondebruin.nl/win/s2/win012.htmKarthik Byggarihttps://www.blogger.com/profile/00511374732538276103noreply@blogger.comtag:blogger.com,1999:blog-967828754174804049.post-78608547298982720022018-07-17T00:13:43.555-07:002018-07-17T00:13:43.555-07:00Hi Nilesh,
You can format in a different color if ...Hi Nilesh,<br />You can format in a different color if any words are omitted by giving the start and end position of word like below -<br /><br />Consider if you want to set the color of first word which is four characters long -<br /><br />With ActiveCell.Characters(Start:=1, Length:=4).Font<br /> .Name = "Arial"<br /> .FontStyle = "Regular"<br /> .Size = 11<br /> .Strikethrough = False<br /> .Superscript = False<br /> .Subscript = False<br /> .OutlineFont = False<br /> .Shadow = False<br /> .Underline = xlUnderlineStyleNone<br /> .Color = -16777024<br /> .TintAndShade = 0<br /> .ThemeFont = xlThemeFontNone<br /> End With<br />Karthik Byggarihttps://www.blogger.com/profile/00511374732538276103noreply@blogger.comtag:blogger.com,1999:blog-967828754174804049.post-87660306065745137552018-06-22T20:42:36.436-07:002018-06-22T20:42:36.436-07:00Thanks for sharing this VBA code.
If I want to com...Thanks for sharing this VBA code.<br />If I want to compare 2 strings in EXCEL and some words which are there in 1st string which are not typed in 2nd string by mistake. How can I show them by changing the font color of the omitted words in BLUE. Is there any VBA to show omitted words.<br />Regards, and Once again thanks for sharing this one.Anonymoushttps://www.blogger.com/profile/01243908586159194443noreply@blogger.comtag:blogger.com,1999:blog-967828754174804049.post-2409525006747780892018-05-09T10:17:12.800-07:002018-05-09T10:17:12.800-07:00How can I show only tabs?How can I show only tabs?Anonymoushttps://www.blogger.com/profile/01616265929289679435noreply@blogger.com