Replace table with Userform

[Newbie999]

Yes I was trying to call the Unprotect and then call the Protect codes in your codes but wasn't successful.

[Zack Barresse]

@paulked: It's a good idea to compartmentalize your code, such as separate routines for protecting and unprotecting, as it keeps your code modular, reusable, and easier to maintain and debug. If this were the only code ever written, then sure, just call it in the routine.

[Newbie999]

Perhaps my requests have made this a nightmare of a workbook. I apologize for not making it a logical format. I think the main issue is have indirect ways of showing the data.

Instead of one input table that the calendar fills from I opted to make the formulas pull from the other table.

Is this the case of going back to the drawing board?

[Newbie999]

I have this version which the formulas pull from the tables directly in columns U to X.

The only issue I forsee with this will be when I have to scroll down to appointments and lose the calendar view.

[paulked]

@paulked: It's a good idea to compartmentalize your code, such as separate routines for protecting and unprotecting, as it keeps your code modular, reusable, and easier to maintain and debug. If this were the only code ever written, then sure, just call it in the routine.

[paulked]

@paulked: It's a good idea to compartmentalize your code, such as separate routines for protecting and unprotecting, as it keeps your code modular, reusable, and easier to maintain and debug. If this were the only code ever written, then sure, just call it in the routine.