Thank you for your reply slaya,
My work book contains more sheets (30sheets per month)
Daily i add one new sheet so i need to check all the sheets
Have you got my point?
Am using excel for daily report.Sheet name refers date (Jan 1 , Jan 2 etc).
daily I update all the project id's (in column A) done on that day. Once I update the project id's I check whether those id's are already done in previews sheet by using Search (ctrl + F) within workbook.
Is there any...
Hi,
Am learning more in Excel and VBA macro day by day using Chandoo's forum. Thanks a lot for that.
I have created one macro for Quiz using user form, i need to include time limit for the quiz. Count down time should run once quiz starts, time limit 10minutes
Can any body help in this
Hi,
In shared workbook Column A contains Fruit's name
For eg:
A1 = Apple ; A2 = Orange ; A3 = Grapes etc
if some one changed the item from A1 "Apple" to "Pineapple" then
I want notification that A1 has been changed from "Apple" to "Pineapple" by username
Notification can be in any way...
Thanks for your reply...
I tried this step but in shared workbook once i entered the password i cant protect the column again.... i need to close the workbook and reopen then only its locked.
Any way i will use this until get some more advance than this
Thank you once again :)
Is there any...
Hi,
In shared workbook i will assign task to my team members daily basis. In column B i assign the processor name for eg: AAA, BBB, CCC, etc
Some people reassigning the project from others without my knowledge so i want to protect "B" column alone from other users. kindly help on this.
Eg...