CODEWITHSUNDEEP
vbaexcel
Shorn Jacob
Shorn Jacob

Reputation: 1251

Triggering of Excel Function

Worksheets("InputSheet").Outline.ShowLevels RowLevels:=1

After excution of this Line, A UDF is triggered and and this UDF ends abruptly for reasons unknown to me.

The UDF is not called directly anywhere in "InputSheet" . Only a NamedCell which is in another sheet using this function is used in "InputSheet".

I dont want the function to be triggered.
Any possible reasons or solutions

Upvotes: 0

Views: 114

Answers (1)

Charles Williams
Charles Williams

Reputation: 23520

Showing and hiding rows often triggers a recalculation, and recalculations involve all worksheets in all open workbooks.
Try setting calculation to Manual.

Upvotes: 1

Related Questions