LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Unable to set installed property of addin

I have a custom add-in I wrote that I want loaded up when another excel file
is loaded. My code:

Dim o As Excel.AddIn

For Each o In Application.AddIns
If o.Name = "Planner.xla" Then
o.Installed = true
Exit For
End If
Next

However, when it tries to set the Installed property, it raises an error:

Runtime error 1004: Unable to set the installed property of the add-in
class.

Any suggestions on what to look for?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Installed Addin file opens when it shouldn't Aaron Excel Discussion (Misc queries) 3 February 6th 08 11:13 PM
Installed property Rights tool, now I cant edit hyperlinks! Your Worst Newbmare Excel Discussion (Misc queries) 0 July 24th 07 07:50 PM
Unable to set the XValues Property Ali Baba Charts and Charting in Excel 2 September 14th 05 04:54 AM
unable to set hidden property davegb Excel Programming 2 March 22nd 05 12:03 AM
Unable to get VLOOKUP property cici Excel Programming 1 February 10th 04 11:24 PM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"