add a comment but thought that here was better. Problem with accessing ribbon

Danmc

New member
Joined
Nov 19, 2015
Messages
4
Reaction score
0
Points
0
Location
Florida, USA
Excel Version(s)
Office 365
got a real head scratcher. When I make an addin as Read Only, one of my procs will open another workbook (not read only). However I can't do anything with it (buttons don't work, ribbon doesn't work, I can only edit cells). This doesn't happen with I am in the Read Write version, only with read only addin. How can I fix this?

do have a workaround. when I open a problematic workbook via userform, I wait till it loads up. then click another open workbook (like Book1), click a cell, then click the File menu (to verify that I have access to the ribbon). then I can go back to the other workbook and finally the ribbon is accessible and can edit and print the workbook.

how to fix?

Dan
 
Much of the functionality for each controls in each of the tabs of the ribbon are only available/enabled when it possible to do actually do something. If a workbook is read-only, there isn't much you can do (you can't edit or manipulate the data), so most of the controls in the ribbons will be disabled until such time as you click somewhere (like an editable cell). The same applies when you have a protected sheet or workbook.

As an aside, why do you need to open the addin in read only mode? By default (and by design), addins are not visible in Excel, and if there is meant to be user interaction with the addin, this is ordinarily through context menus/menus, the ribbon, the commandbar, etc. Sometimes an addin might have worksheets on which it will store data, etc or use as a form of user input, but in those cases, I think that the standard approach is to make a copy of the worksheet into a new or existing workbook, and then process the user input from that sheet rather than change the data on (what are ordinarily) hidden worksheets. Even then, if there is concern about the user editing the contents of (even) hidden worksheets, then the usual approach would be to protect the worksheet rather than loading the addin in read-only mode.
 
Not really following the problem, can you post the addin so we can try it?
 
Back
Top