Add Ins error

kkondrat1

New Member
Joined
Nov 10, 2005
Messages
9
Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
'SetScrollAreas
'Sheets("Assumptions").Select
'identify_write_access
End Sub

When i open the sheet I receive this error-

"Run time error '7': Out of memory

any ideas?
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
The code is good, I think you probably are out of memory ( :biggrin: ) How much do you have on your machine?
 

kkondrat1

New Member
Joined
Nov 10, 2005
Messages
9
Out of memory

I have 512, I don't know how memory could be an issue for a simple macro command like this-

I am opening this sheet from a hyperlink, could that be an ussue?
 

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
Hmm just a thought to try... Instead of putting it in workbook open try putting it in a module and naming the sub Auto_Open.

Might fix it. (Might not too :confused: )
 

Watch MrExcel Video

Forum statistics

Threads
1,118,018
Messages
5,569,646
Members
412,285
Latest member
Daibear
Top