cancel
Showing results for 
Search instead for 
Did you mean: 

Macro Logic to Grey Sundays

Former Member
0 Kudos

Hi Experts

we are not using any calenders in DP , so we are using data view which has daily time bucket profile.

I need to block (grey all sundays) in the data view.

Please help me which macro function i need to use.

regards

Rave

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

This is the logic using the functions weekday() and cell_input(). This shud do the work.

Step x iterations.

If weekday(

Row name

)

=

7.

row name =

cell_input(

0

)

endif.

row name is the name of the row for which you want to apply these changes.

Use Weekday(row name) to find out the day. If it is 7 then it is sunday.

After this use row_name = cell_input(0) to set the cell as read only. Hope this solves the problem.

For the weekday function remember to change the 'row name' Data properties from values to 'Column Attributes'.

For the cell_input function change the 'Change Mode' of the 'row name' from value change to attribute change.

Hope this helps.

Thanks

Mani

Former Member
0 Kudos

Hi,

Pls confirm, if this was helpful.

Thanks

Mani

Former Member
0 Kudos

Thanks Mani..

Inforation provided by you is very helful.

Closing this Thread.

regards