VBA: msgbox doesn't work

[yky]

msgbox "This Worksheet is not password protected"

Does anyone know what's wrong with the above code?

If the code is working, Excel automatically changes msgbox to MsgBox. Now, Excel doesn't do that and I got an error message saying "Object variable or With block variable not set.."

Is msgbox now a variable?

 

[Fluff]

Best guess is you created a variable called msgbox.

 

[yky]

Thanks for the reply.

Can reserved words be used as variable names? I thought that couldn't be done.

I suspected the file was corrupted. So, I copied the module to a newly created file, saved it, and then opened it. "msgbox" became "MsgBox". Even without running the code, I knew the problem had been solved.

 

[Fluff]

There are some words that cannot be used for the names of variables, but most can be used.
But you can use MsgBox as a variable or the name of a procedure, although it may cause problems.