TM1 Forum

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,

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.

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 .