PDA

View Full Version : How to disable Heading Control, via VBA in the Ribbon, View Tab



iandix
05-25-2015, 10:57 PM
Hi,
I would deseable Heading Control in the View Tab when the user opens a specific worksheet, and I should refresh the some control on closing, set it as enabled.

My goal: the user cannot click on Heading Control in the View Tab according to show/hide heading for this specific worksheet.

I was able to set Heading as ON or OFF via VBA, but is not enough for my, I want to get che control unmanageable by the user, maybe i sould set as OFF and then protect it, but I don't know how do this.

Thank you for your patiance and for coming help.

Bye
iandix

SamT
01-22-2016, 08:32 PM
If you are still interested, I just moved this to the Excel Help Forum.

People should wait for iandix should reply before posting to this thread, it is 7 months old.