ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Toggle Button in Ribbon to Hide/Show Built-in Tabs (https://www.excelbanter.com/excel-programming/408412-toggle-button-ribbon-hide-show-built-tabs.html)

Don[_30_]

Toggle Button in Ribbon to Hide/Show Built-in Tabs
 
I have consulted several developer sites in the hopes of being able to
create this toggle button. I'm trying to follow this post:

(http://msdn2.microsoft.com/en-us/library/bb421511.aspx)

explicitly, but I'm geting several errors in the VBE before I can even
test the code. It looks like VB doesn't expect

"Private showViewTabBool As Boolean = False"

to assign a value to the variable. I get an error "Expected end of
statement" at the "=". The call "myRibbon.Invalidate()" expects to be
equal to something and has syntax error with the parentheses. PLEASE
HELP. I have created the rest of my ribbon and can't get the ribbon
to update on command.


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com