Sub Worksheet_Change(ByVal Target As Excel.Range)
I think I am close, but I am getting an "End If without block If" error on the If Clause. If the user selects that cell again, they will get the usual pop-up message, "The cell or chart that you are trying to change is protected." If a user enters a date in a cell or range of cells anywhere in the column, the changed cells also need to be locked and protected (Once they enter a date, it is not allowed EVER to be changed again. I have named the cells in that column "MS96A". I have a worksheet that is locked and protected now, except for cells in a certain collumn. Which is the only current way I can get rid of it. Is there some shortcut to turn off this highlight feature other than restarting The cursor is still stuck in the highlighting mode and won't perform anyĭo you think this is a problem with my computer, the excel program? I have changed my mouse and this didn't help. I can close it only with the task manager but when I open it again, I can't select anything from the tool bars, do any work on the sheet or close the program. The biggest problem is that the highlighting won't turn off, no matter When I return to excel thousands and thousands of cells are blue.
I move even in those other programs (I know this sounds confusing). Program on my computer, that excel page keeps highlighting wherever The cell turns blue and then wherever I move, it highlights those to. I will click on a cell to add information. P.S for the calender drop down on the main page, i'm using 'microsoft time & date picker 6.0) If just someone could point me in the right direction, i would be appreciate it so much words can't express!!!
I am volunteering for a non profit organization and trying to create a reservation system for the rooms that they have - kind of like hotel software, but in excel (i did a similiar thing in college but for plane seats)Ĭopy all of the info from the main page to the guest lit (a new row each time).įrom the guest list to the Gannt chart - i did a few tutorials on dynamic gantt charts using conditional formatting but cannot get them to work when based on data on a different worksheet.įinaly is there a way to check for availabilty on any given date? So i'm having to re-learn 99.9% of everything i once new. Firstly i haven't used excel to a great extent since my college days.
0 kommentar(er)
