Hide ribbons when Macros are disabled

I dont think you can as the macro will need to be triggered, can you hide them before save, and then show on a macro?

You can use the getVisible callback to make tabs visible. Of course if macros are not enabled they will not be shown.

Not sure how hiding the ribbon protects your code though

This might help

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Hide ribbons on Workbook_BeforeClose sub. On Workbook_open enable ribbons/
If macros will be disabled then the ribbons will not be shown.
It is the simpliest and weakest way to protect your file.

may be this will help: http://www.ozgrid.com/VBA/excel-add-in-create.htm

Thinking about this if your are worried about users using another workbook to break yours doing stuff to the ribbon will have no affect.
When they open the other workbook it will display it's own ribbons.

@Andy: I'm having a blonde moment or, more accurately, a grey moment. Can you explain the process here, please. Do you have to do something to the workbook before you save and close it? Or can you just insert that code into any macro enabled workbook? Clearly, it's not as simple as that ... I just tried. So how do you prepare the workbook so that this works?

Regards, TMS

I did forget to mention you need to add ribbon xml to the file.

<customUI
xmlns="http://schemas.microsoft.com/office/2006/01/customui"
onLoad="rbxUI_onLoad">
<ribbon >
<tabs >
<tab
idMso="TabHome"
getVisible="HasMacros"/>
<tab
idMso="TabInsert"
getVisible="HasMacros"/>
<tab
idMso="TabPageLayoutExcel"
getVisible="HasMacros"/>
<tab
idMso="TabFormulas"
getVisible="HasMacros"/>
<tab
idMso="TabData"
getVisible="HasMacros"/>
<tab
idMso="TabReview"
getVisible="HasMacros"/>
<tab
idMso="TabView"
getVisible="HasMacros"/>
<tab
idMso="TabDeveloper"
getVisible="HasMacros"/>
<tab
idMso="TabAddIns"
getVisible="HasMacros"/>
<tab
idMso="TabPrintPreview"
getVisible="HasMacros"/>
</tabs >
</ribbon >
</customUI >

Okay ... I'm beginning to feel like a 5 year old now

... you need to add ribbon xml to the file.

How do you do that then?

Regards, TMS

You can either do it manually by changing to zip file and editing files within the zip folder.
Or use some tool created to do it.

They is lots of information here
http://www.rondebruin.nl//win/section2.htm

and I have a tool and some information here
http://www.andypope.info/vba/ribboneditor.htm
http://www.andypope.info/vba/ribboneditor_2010.htm

@Andy: Thank you. Looks interesting (and very useful). Cheers

@xlman: you're welcome, glad to have been of help. I had to ask, it's not something I've done either.

Regards, TMS



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.