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
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