Add-in error message

btadams · Feb 18th 2003

I've created an add-in with some functions. If I Go to Tools -> Add-ins and load it up there are no problems. However, when I close and re-launch Excel there is an error message about editing a hidden workbook and the line that seems to be causing the error is:

Application.MacroOptions macro:="INTERPOLATE", Category:=4

any ideas as to why? Thanks,

yjoshi · Mar 27th 2003

Cannot dig this only with one line of code :nono:

Can you give some other lead???

**Jack in the UK** · Mar 27th 2003

Bit difficult this one with few details but suggest:

Un-hiding sheets on open and hid at end of procedure.

If the data is confidential made all the text white, so it look blank and select range(“A1”) or any dead cell just in case, then re-hide and select you chosen sheet

Dose that help you?

Kindest possible regards

Jack in the UK

Add-in error message

Participate now!

Share