Hi everyone,
I simply need to disable / enable the “Share Workbook” button on demand via VBA in Excel 2010.
I have seen Ron de Bruin’s ribbon explanation using XML, but I could not get that to work.
I have tried Chip Pearson's VBA sample from http://www.cpearson.com/excel/menus.htm, but could not get that to work.
I also have already tried (from Google search) application.commandbars.FindControl(ID:=2040).Enable=False … or true… but that does not work either.
I need to be able to do this from VBA and on demand.
“Help me, Obi-Wan Kenobi. You're my only hope. “
Thanks in advance!
NJDevil
Bookmarks