Active forms - edit rowset macro

Post Reply
stex2727
Posts: 66
Joined: Tue Sep 15, 2009 11:29 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Active forms - edit rowset macro

Post by stex2727 »

Hi all,

Not sure if this is common knowledge but the following macro will show the subset editor for an active form so you can adjust the rowset.

Range("A1").Select
Application.Run "tm1rowedit"

where range "A1" contains the activeform's TM1RPTROW formula

Steve
dubs
Posts: 131
Joined: Fri May 22, 2009 10:43 am
Version: 9.4
Excel Version: 2003

Re: Active forms - edit rowset macro

Post by dubs »

Nice spot, will try that out
Post Reply