Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to enable read only feature for charts and objects in the dashbaord. I have set of buttons in the dashboard to print, when I enable the read only property by Rightclick-> Security-> Read only ( apply to all sheets) . These button are becoming and unable to click them.
I have a work around for this to not to check the - Read only from Security tab , but create a Macro with all the objects. But this is a time consuming process as I have many objects to list them in the Macro.
Sub ReadOnly
set chart = ActiveDocument.GetSheetObject("CH959")
set p = chart.GetProperties
p.ReadOnly = true
chart.SetProperties p
When I tried making read only property for the button as false, below error is dispalyed in the macro
" This object does not support this feature".
I there a way to disable read only functionality for buttons ?
Have you considered only making the charts and list boxes read-only and not the buttons? You should be able to do this individually for most objects.