on 03-18-2010 4:52 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.