smozgur, I thought I had it fixed however, as soon as I closed Excel "Mr Excel" disappeared from sheet , though the add-in box was ticked
II can get "Mr Excel" to show on sheet and use it by locating it in Documents and double clicking.
However, when i close and reopen sheet it disappears and to get it back I need to repeat this process.
Having said that after active excel sheets are closed a blank sheet remains and it shows "Mr excel" and when I click on capture range it shows "there is no active workbook"
Have tried everything to overcome without success.
At the moment the file is in Temp as well as documents and a shortcut is on desktop
When opening I get message "sorry we couldn't find temp fle" (see image below)
The image below also shows other messages
Any suggestions on what i am doing wrong.