Macro in PAW

Post Reply
manu0521
Posts: 81
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

Macro in PAW

Post by manu0521 » Mon May 18, 2020 4:39 pm

Hi ,

I have a small macro in my pax sheet , which is on change of a selection of a list ,clear a cell value .

It worksfine in PAX ,but not in PAW.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$F$3" Then
Range("F15:F17").ClearContents
End If

Is this the behaviour that macros will not work with PAW or is there a workaround that we can do .

Thanks,

tomok
MVP
Posts: 2724
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Macro in PAW

Post by tomok » Mon May 18, 2020 5:27 pm

manu0521 wrote:
Mon May 18, 2020 4:39 pm
Is this the behaviour that macros will not work with PAW or is there a workaround that we can do .
Yes, that is the normal behavior. PAW does not support VBA and never will. Workarounds depend on whatever it is you are doing with the macro and if there is native way to do that in TM1.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

manu0521
Posts: 81
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

Re: Macro in PAW

Post by manu0521 » Tue May 19, 2020 12:33 pm

so i have a pax sheet which is uploaded to paw ,

the first sheet is data entry sheet and has a date format and paw picks it as date and shows a calender picker.
One thing to be noted is we are not able to empty the cell when a value is selected in date picker, it has to either default to 1900

This sheet is fine as this field is a manatory field .

So i store this value in a attribute in tm1 which is text .

Now on a another sheet i have to use this value as a non mandatory field , ,menaing user can chnage it or not .

1) issue is its not showing as a datepicker in paw , because the formula on the cell is

=DBRA("BB-bkup:Lease",$E$4,A10) but the format is still mm/d/yy

2) if i ont protect the cell it overwrittes to empty when user deletes it .

Post Reply